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.
Syntax
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| user | Authorization identifier of a specific user that you are dropping. | Must be an existing authorization identifier | Owner name |
Usage
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.
Example
The following statement drops the user bill:
DROP USER bill;