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