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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
