Re: How to drop user if objects depend on it
От | Andrus |
---|---|
Тема | Re: How to drop user if objects depend on it |
Дата | |
Msg-id | F57C7C4919884A3A9ECD9591007F17DE@dell2 обсуждение исходный текст |
Ответ на | Re: How to drop user if objects depend on it (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: How to drop user if objects depend on it
|
Список | pgsql-general |
>> ALTER DEFAULT PRIVILEGES IN SCHEMA public,firma1 GRANT all ON TABLES TO >> vantaa; >I am not sure that REASSIGN OWNED will get rid of default-privilege >specifiers --- you might have to reverse this step separately. >In general, REASSIGN OWNED has to be done by a role that has privileges >of (is a member of) both the source and target roles. Superusers are >considered members of all roles, so that's how come it works for them. I tried as superuser: reassign owned by farukkugay to postgres; ALTER DEFAULT PRIVILEGES IN SCHEMA public,firma2 revoke all ON TABLES from farukkugay; drop user farukkugay ; but got error ERROR: role "farukkugay" cannot be dropped because some objects depend on it SQL state: 2BP01 Detail: privileges for schema public How to to delete user ? Andrus.
В списке pgsql-general по дате отправления: