First do:
DROP OWNED BY user1;
then:
drop role user1;
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] dropping a user in 8.2.6
I am using
I am using version 8.2.6
I created a role and granted all on table "instrument" in the database. But,
when I tried to drop the role, I get the following error:
mydb=# drop role system_dba;
ERROR: role "user1" cannot be dropped because some objects depend on it
DETAIL: access to table mydb_a
