Drops an 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.
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 will appear 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')
