DROP USER
The
DROP USER
statement removes an existing user account(s) from a database.
Syntax
DROP USER
user-name
[ ,
user-name
]...
Remarks
This function is an extension to SQL grammar as documented in the
Microsoft ODBC Programmer’s Reference
.
Only the Master user can execute this statement.
Security must be turned on to perform this statement.
Separate multiple user names with a comma.
The user name must be enclosed in double quotes if it contains spaces or other non-alphanumeric characters.
Dropping a user account does not delete the tables, views, or other database objects created by the user.
For further general information about users and groups, see
Master User
and
Users and Groups
in
Advanced Operations Guide
.
Examples
The following example removes the user account
pgranger
.
DROP USER pgranger
============
The following example removes multiple user accounts.
DROP USER pgranger, “lester pelling”
See Also
ALTER USER
CREATE USER