sp_iqdroplogin Procedure

Drops a Sybase IQ user account.

Syntax1

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.

Parameters
Parameter	Description
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')