https://gombemi.ccas.gwu.edu/gombemiwiki/index.php?action=history&feed=atom&title=DeleteDBUserDeleteDBUser - Revision history2026-05-17T02:44:58ZRevision history for this page on the wikiMediaWiki 1.27.4https://gombemi.ccas.gwu.edu/gombemiwiki/index.php?title=DeleteDBUser&diff=74&oldid=prevKarlPinc: New page2015-09-29T18:40:49Z<p>New page</p>
<p><b>New page</b></p><div>== Deleting a Database User ==<br />
There is no web page for deleting a database user.<br />
Deletion must be done with SQL statements by a user with administrative privileges.<br />
<br />
=== Listing All Users ===<br />
<br />
The following query lists all users and groups:<br />
<br />
<code><br />
select rolname as "user/group"<br />
, rolsuper as administrator<br />
from pg_roles<br />
order by rolname;<br />
</code><br />
<br />
=== Deleting a User ===<br />
<br />
Before deleting a user the user's schemas must be deleted.<br />
Since administrative users do not usually have their own<br />
private schemas, schema deletion need only be done for<br />
regular users.<br />
<br />
First connect to the gombemi_test database, as an administrative user.<br />
<br />
<code><br />
drop schema SOMEUSER cascade;<br />
</code><br />
<br />
Then connect to the gombemi database, as an administrative user.<br />
<br />
<code><br />
drop schema SOMEUSER cascade;<br />
drop role SOMEUSER;<br />
</code></div>KarlPinc