Can't Drop Role

Started by Carlos Mennensabout 13 years ago2 messagesgeneral
Jump to latest
#1Carlos Mennens
carlos.mennens@gmail.com

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Leif Gunnar Erlandsen
leif@basefarm.no
In reply to: Carlos Mennens (#1)
Re: Can't Drop Role

You should alter owner of the functions.

Try "alter function function_name owner to new_owner;

Leif Gunnar Erlandsen

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general