Drops a Sybase IQ user account.
call sp_iqdroplogin (‘userid’)
sp_iqdroplogin ‘userid’
sp_iqdroplogin userid
sp_iqdroplogin (‘userid’)
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
userid User ID of the user to drop.
sp_iqdroplogin drops the specified user.
The following stored procedure calls remove the user rose.
sp_iqdroplogin 'rose'
sp_iqdroplogin rose
call sp_iqdroplogin ('rose')
REVOKE statement in Reference: Statements and Options
Chapter 8, “Managing User IDs and Permissions,” in System Administration Guide: Volume 1
