Re: Drop role cascade ?
| От | Ron |
|---|---|
| Тема | Re: Drop role cascade ? |
| Дата | |
| Msg-id | c744908b-befc-07fc-1e3b-d0329cd6d83f@gmail.com обсуждение |
| Ответ на | Drop role cascade ? (David Gauthier <dfgpostgres@gmail.com>) |
| Список | pgsql-general |
On 11/17/22 17:07, David Gauthier wrote: > psql (11.5, server 11.3) on linux > > Someone who had privileges in a lot of tables/schemas/DBs left the > company. I want to drop that role but "rop role xxx" won't let me > because... "xxx cannot be dropped because some objects depend on it". > > Is there a way to just get rid of this role without revoking xxx in all > the individual DB objects he has privs too? Something like "drop role xxx > cascade" ? Had this idea tonight about how to find what is owned by a specific role. Haven't tested it, so the syntax might be a bit wrong, and it might not work: $ pg_dump --schema-only $DATABASE | grep OWNER | grep $OLDEMPLOYEE -- Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: