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:

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

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.

drop schema SOMEUSER cascade;

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

drop schema SOMEUSER cascade;
drop role SOMEUSER;