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 | 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 | Immediately expire all user passwords | 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 passwords. CHANGE PASSWORD system privilege is required to change the password of another user. |