default privileges
От | Jaime Casanova |
---|---|
Тема | default privileges |
Дата | |
Msg-id | r2o3073cc9b1004031349p98314100xdc007bbe6ff00e97@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: default privileges
|
Список | pgsql-hackers |
Hi, I create some default privileges, now i'm trying to drop those roles but i get this error: """ mic=# drop role jcm; ERROR: role "jcm" cannot be dropped because some objects depend on it DETAIL: owner of default privileges on new relations belonging to role jcm in schema public """ So i look for default privileges and try to REVOKE privileges for all roles i found here """ mic=# \ddp Default access privileges Owner | Schema | Type | Access privileges ----------+--------+-------+-------------------jcm | public | table |jcm1 | public | table |postgres | public |table |rup | public | table | (4 rows) """ but i still have the same error when trying to drop the role, so the questions are: what is the role that owned the default the one in FOR ROLE target or the one in the "simplified grant", i guess it's the first one... but i try REVOKE in all combinations and nothing works... maybe the \ddp needs to show more info? or we need a CASCADE clause in the DROP ROLE? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
В списке pgsql-hackers по дате отправления: