Delete Users and Their Schemas¶

Only users in the useradmin group have the privilege to maintain other users.

To delete a user’s database schema and the data it contains

1. Connect to the User Management database (iidbdb) as a useradmin user (for example, dbuser) and connect to the iidbdb database.
2. Change the password of the user whose schema you want to delete. For example:

alter user testuser1     with password='mypassword'

1. Connect to the Actian database as the user you want to delete (testuser1) using the password supplied in step 2.
2. Drop the schema of the user. For example:

drop schema testuser1 cascade

To delete a user

Connect to the User Management database (iidbdb) as a useradmin user (for example, dbuser) and execute the drop user statement:

drop user testuser1;

More information:

• ALTER USER

• DROP SCHEMA

• DROP USER