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.