Search Postgresql Archives

Re: Bug, Feature, or what else?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2013/2/8 Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>
How can i drop a user as SUPERUSER (!) with all privileges?

According to the docs: http://www.postgresql.org/docs/current/interactive/sql-droprole.html

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux