Hi,
i have created a normal user (no superuser) akretschmer01 and another norma=
l
user ak02. All fine.
The first user is the owner of the db.
As user akretschmer01 i granted:
-bash-4.1$ psql -U akretschmer01 db115150
psql (9.1.8)
Type "help" for help.
db115150=3D> grant all on schema public to ak02;
GRANT
db115150=3D> commit;
There are no tables or other objects createt as user ak02.
Now i switched to user postgres (superuser):
-bash-4.1$ psql -U postgres db115150
psql (9.1.8)
Type "help" for help.
db115150=3D# drop user ak02
db115150-# ;
FEHLER: kann Rolle =C2=BBak02=C2=AB nicht l=C3=B6schen, weil andere Objekt=
e davon abh=C3=A4ngen
DETAIL: Privilegien f=C3=BCr Schema public
(role ak02 cannot be dropped because some objects depend on it, Detail:
privileges for schema public)
I can revoke all on database from user:
db115150=3D# revoke all on database db115150 from ak02;
REVOKE
db115150=3D# drop user ak02;
FEHLER: kann Rolle =C2=BBak02=C2=AB nicht l=C3=B6schen, weil andere Objekt=
e davon abh=C3=A4ngen
DETAIL: Privilegien f=C3=BCr Schema public
but still i can't drop the user.
I can do that with 9.1.8 and 9.1.1 too, same problem.
How can i drop a user as SUPERUSER (!) with all privileges?
Regards, Andreas