The Login_DropLogin() function is used to drop a SQL login.
Login_DropLogin(user_ID)
• user_ID – A string specifying the ID of the user login that is being dropped.
An integer specifying the status of the operation. The following table lists the constants that correspond to the values that can be returned.
![[spacer]](1p.gif){kind=small}
|
Constant |
Description |
|---|---|
|
STATUS_SUCCESS |
Operation was successful. |
|
STATUS_MEMORY_ERROR |
A memory error occurred. |
|
STATUS_TOO_MANY_CONNECTIONS |
Too many SQL connection in use to perform the operation. |
|
STATUS_DATASOURCE_REJ |
The SQL server rejected the operation. |
|
STATUS_UNABLE_TO_CONNECT |
Unable to connect to the data source. |
|
STATUS_LOGIN_LOCKED |
Login is locked. |
|
STATUS_LOGIN_INVALID |
The login is not valid to perform the operation. |
|
STATUS_INVALID_PERMISSIONS |
The login had invalid permissions to perform the operation. |
|
STATUS_NOT_LOGGED_IN |
No user is logged in to perform the operation. |
The current user must have SQL administrative privileges to drop a login.