Deleting database users

You can use the DROP USER command to delete or drop a database user account.

To drop the account, log in to the database by using an account that has Drop administrative privilege. For example, the following command drops the dlee user account:
SYSTEM.ADMIN(ADMIN)=> DROP USER dlee;
DROP USER

The command displays an error if the account that you want to drop owns objects; you must change the ownership of those objects or drop those objects before you can drop the user.