From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | default privileges |
Date: | 2010-04-03 20:49:03 |
Message-ID: | r2o3073cc9b1004031349p98314100xdc007bbe6ff00e97@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2010-04-03 20:50:28 | Re: \d commands in psql 9.0 |
Previous Message | Tom Lane | 2010-04-03 20:46:14 | Re: \d commands in psql 9.0 |