DROP USER statement (UNIX, Linux)

Use the DROP USER statement to remove an internal user.

This statement is an extension to the ANSI/ISO standard for the SQL language.


1  DROP USER user
Element Description Restrictions Syntax
user Authorization identifier of a specific user that you are dropping. Must be an existing authorization identifier Owner name


Only a DBSA can run the DROP USER statement. With a non-root installation, the user who installs the server is the equivalent of the DBSA, unless the user delegates DBSA privileges to a different user.

It is recommended that you do not run the DROP USER statement while the specified user is active on a connection.

Execution of the DROP USER statement can be audited with the DRUR audit code.


The following statement drops the user bill: