Drops a Sybase IQ user account.
call sp_iqdroplogin (‘userid’)
sp_iqdroplogin ‘userid’
sp_iqdroplogin userid
sp_iqdroplogin (‘userid’)
DBA authority required.
userid User ID of the user to drop.
Chapter 12, “Managing User IDs and Permissions” in Sybase IQ System Administration Guide
sp_iqdroplogin drops the specified user, and removes the user from the IQ_USER_LOGIN_INFO_TABLE.
By default, you can only drop users with sp_iqdroplogin on a multiplex write server. To enable sp_iqdroplogin on query servers, you must set the database option MPX_LOCAL_SPEC_PRIV to change the default. For details, see “MPX_LOCAL_SPEC_PRIV option”.
The following errors may occur. Causes are listed after each error.
Permission denied: You do not have permission to execute the procedure sp_iqdroplogin.
Cause: A user without DBA role tried to execute sp_iqdroplogin.
RAISERROR executed: User <loginname> does not exist.
Cause: The message appears if the user tries to drop a nonexistent login.
The following stored procedure calls remove the user rose.
sp_iqdroplogin 'rose'
sp_iqdroplogin rose
call sp_iqdroplogin ('rose')
