agora inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Andreas Kretschmer <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Bug, Feature, or what else?
Date: Fri, 08 Feb 2013 06:52:24 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <119745304.24731.1360333559327.JavaMail.open-xchange@ox.ims-firmen.de>
References: <119745304.24731.1360333559327.JavaMail.open-xchange@ox.ims-firmen.de>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-general>
On 02/08/2013 06:25 AM, Andreas Kretschmer wrote:
> Hi,
>
> i have created a normal user (no superuser) akretschmer01 and another normal
> 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=> grant all on schema public to ak02;
> GRANT
> db115150=> 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=# drop user ak02
> db115150-# ;
> FEHLER: kann Rolle »ak02« nicht löschen, weil andere Objekte davon abhängen
> DETAIL: Privilegien für 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=# revoke all on database db115150 from ak02;
> REVOKE
> db115150=# drop user ak02;
> FEHLER: kann Rolle »ak02« nicht löschen, weil andere Objekte davon abhängen
> DETAIL: Privilegien für 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?
I believe you will need to REVOKE ALL ON SCHEMA public FROM ak02.
REVOKE ALL ON DATABASE does not mean revoke all privileges for all
objects in the database. It only applies to DATABASE privileges-CONNECT,
CREATE, TEMP
>
>
>
> Regards, Andreas
>
>
--
Adrian Klaver
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
view thread (23+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Bug, Feature, or what else?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox