sp_iqdroplogin Procedure

Drops an SAP Sybase IQ user account.

Syntax1

call sp_iqdroplogin (‘userid’)

sp_iqdroplogin ‘userid’

sp_iqdroplogin userid

sp_iqdroplogin (‘userid’)

Requires the MANAGE ANY USER system privilege. Users without MANAGE ANY USER system privilege must be granted EXECUTE permission.

Parameters
Parameter	Description
userid	ID of the user to drop.

sp_iqdroplogin drops the specified user.

These commands all remove the user rose:

sp_iqdroplogin 'rose'

sp_iqdroplogin rose

call sp_iqdroplogin ('rose')