DROP USER user-name 

You must have the MANAGE ANY USER system privilege.

Dropping a user also deletes all database objects (such as tables or procedures) that they own, as well as any external logins for the user. In addition, if the user is specified in the USER clause of any services, then those services are also dropped.

The user being removed cannot be connected to the database when the statement is executed.

None.

• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• CREATE LOGIN POLICY statement
• CREATE USER statement
• DROP LOGIN POLICY statement
• Login policies

The following example creates and then drops the user SQLTester.

CREATE USER SQLTester IDENTIFIED BY pass1234;
DROP USER SQLTester;