View source for DeleteDBUser

== Deleting a Database User ==
There is no web page for deleting a database user.
Deletion must be done with SQL statements by a user with administrative privileges.

=== Listing All Users ===

The following query lists all users and groups:

<code>
 select rolname as "user/group"
      , rolsuper as administrator
   from pg_roles
   order by rolname;
</code>

=== Deleting a User ===

Before deleting a user the user's schemas must be deleted.
Since administrative users do not usually have their own
private schemas, schema deletion need only be done for
regular users.

First connect to the gombemi_test database, as an administrative user.

<code>
 drop schema SOMEUSER cascade;
</code>

Then connect to the gombemi database, as an administrative user.

<code>
 drop schema SOMEUSER cascade;
 drop role SOMEUSER;
</code>