Adaptive Server Enterprise system procedures provided in SAP Sybase IQ:
System procedure |
Description |
Permissions |
---|---|---|
sp_addlogin userid, password[, defdb [, deflanguage [, fullname]]] |
Adds a new user account to a database |
Requires the MANAGE ANY USER system privilege. |
sp_addmessage message-num, message_text [, language] |
Adds user-defined messages to SYSUSERMESSAGES for use by stored procedure PRINT and RAISERROR calls |
Requires the CREATE MESSAGE or CREATE ANY OBJECT system privilege. |
sp_addtype typename, data-type, [, "identity" | nulltype] |
Creates a user-defined data type. SAP Sybase IQ does not support IDENTITY columns. |
Requires the CREATE DATATYPE or CREATE ANY OBJECT system privilege. |
sp_adduser userid [, name_in_db [, grpname]] |
Adds a new user to a database |
Requires MANAGE ANY USER system privilege to create a new user. Requires MANAGE ANY USER and MANAGE ROLES system privileges to create a new user and add the user to the role specified. |
sp_dboption [dbname, optname, {true | false}] |
Displays or changes database options |
None required. |
sp_droplogin userid |
Drops a user from a database |
Requires MANAGE ANY LOGIN POLICY system privilege. |
sp_dropmessage message-number [, language] |
Drops user-defined messages |
Requires the DROP MESSAGE system privilege. |
sp_droptype typename |
Drops a user-defined data type |
Requires the DROP DATATYPE system privilege. |
sp_dropuser userid |
Drops a user from a database |
Requires the MANAGE ANY USER system privilege. |
sp_getmessage message-num, @msg-var output [, language] |
Retrieves stored message strings from SYSUSERMESSAGES for PRINT and RAISERROR statements. |
None required. |
sp_helptext 'owner.object-name' |
Displays the text of a system procedure or view |
None required. |
sp_password caller_passwd, new_passwd [, userid] |
Adds or changes a password for a user ID |
No system privilege is required to change your own password. The CHANGE PASSWORD system privilege is required to change the password of another user. |
sp_helptext 'owner.procedure_name'
sp_helptext 'myname.myprocedure'