| From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Can't Drop Role |
| Date: | 2013-03-08 12:53:04 |
| Message-ID: | CAAQLLO4XMCpBSp18-vJNy_qY_331m_QdaL1VGBnnP4W2WMKZbQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
For some reason I'm removed all grants and roles from this users
account but I'm unable to remove / drop him from the database as
follows:
postgres=# \du
List of roles
Role name | Attributes
| Member of
-----------+----------------------------------------------------------------+-----------
cmennens | No inheritance, Cannot login | {}
jmadeline | Superuser, No inheritance, Create role, Create DB, Replication | {}
mrbs | No inheritance | {}
mwilshaw | No inheritance | {}
postgres | Superuser, Create role, Create DB, Replication | {}
rcube | No inheritance | {}
postgres=# DROP ROLE cmennens;
ERROR: role "cmennens" cannot be dropped because some objects depend on it
DETAIL: owner of function pg_logfile_rotate()
owner of function pg_file_length(text)
owner of function pg_file_read(text,bigint,bigint)
owner of function pg_logdir_ls()
owner of function pg_file_unlink(text)
owner of function pg_file_rename(text,text)
owner of function pg_file_rename(text,text,text)
owner of function pg_file_write(text,text,boolean)
owner of extension adminpack
--
Carlos Mennens
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2013-03-08 13:45:46 | Re: Password Security Standarts on PostgreSQL |
| Previous Message | Albe Laurenz | 2013-03-08 12:07:10 | Re: Password Security Standarts on PostgreSQL |