Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug, Feature, or what else? - Mailing list pgsql-general

From Виктор Егоров
Subject Re: Bug, Feature, or what else?
Date
Msg-id CAGnEboh0irztEFK47CgF=jpx3VHCi-5LWjcA67RF2xLsn0q-nA@mail.gmail.com
Whole thread Raw
In response to Bug, Feature, or what else?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
2013/2/8 Andreas Kretschmer <andreas@a-kretschmer.de>
How can i drop a user as SUPERUSER (!) with all privileges?


> A role cannot be removed if it is still referenced in any database of the cluster;
> an error will be raised if so. Before dropping the role, you must drop all the objects
> it owns (or reassign their ownership) and revoke any privileges the role has been
> granted. The REASSIGN OWNED and DROP OWNED commands can be useful for this purpose. 


--
Victor Y. Yegorov

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Bug, Feature, or what else?
Next
From: Albe Laurenz
Date:
Subject: Re: Decrease the time required function