Manage Connections Using Stored Procedures

There are several stored procedures for managing user connections.

This table lists the procedure available to perform each SAP Sybase IQ login management function.

Stored Procedure	Purpose	System Privilege Required
sa_get_user_status	Retrieve the current status of all existing users	Requires the MANAGE ANY USER system privilege to retrieve the current status of all existing users. Users without the MANAGE ANY USER system privilege can retrieve only their current status.
sp_expireallpasswords	Cause all user passwords to expire immediately	MANAGE ANY USER system privilege
sp_iqaddlogin	Add users, define their passwords, specify login policy, and password expiry on next login	MANAGE ANY USER system privilege
sp_iqcopyloginpolicy	Create a new login policy by copying an existing one	MANAGE ANY LOGIN POLICY system privilege
sp_iqdroplogin	Drop the specified user	MANAGE ANY USER system privilege
sp_iqmodifylogin	Assign a given user to a login policy	MANAGE ANY USER system privilege
sp_iqmodifyadmin	Set an option on a named login policy to a certain value	MANAGE ANY LOGIN POLICY system privilege
sp_iqpassword	Change your own or another user’s password	All users can run sp_iqpassword to change their own password. However, the CHANGE PASSWORD system privilege is required to change the password of another user.