Caché SQL Reference
DROP USER
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Removes a user account.
Synopsis
DROP USER user-name
Arguments
user-name The name of the user to be removed.
Description
The DROP USER command removes a user account. This user account was created and the user-name specified using CREATE USER. If the specified user-name does not correspond to an existing user account, Caché issues an SQLCODE -118 error. User names are not case-sensitive.
You can also delete a user from the Management Portal. Select [Home] > [Security Management] > [Users] to list the existing users. On this table of user accounts you can click Delete for the user account you wish to delete.
Privileges
The DROP USER command is a privileged operation. Prior to using DROP USER in embedded SQL, it is necessary to be logged in as a user with appropriate privileges. Failing to do so results in an SQLCODE -99 error (Privilege Violation).
Use the $SYSTEM.Security.Login() method to assign a user with appropriate privileges:
   DO $SYSTEM.Security.Login("_SYSTEM","SYS")
   &sql(      )
You must have the %Service_Login:Use privilege to invoke the $SYSTEM.Security.Login method. For further information, refer to %SYSTEM.Security in the InterSystems Class Reference.
Examples
You can drop PSMITH by issuing the statement:
DROP USER psmith
See Also