Adaptive Server Enterprise System Procedures

Adaptive Server Enterprise system procedures provided in SAP Sybase IQ:

ASE 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.

Note: Procedures like sp_dropuser provide minimal compatibility with Adaptive Server Enterprise stored procedures. If you are accustomed to Adaptive Server Enterprise, compare their text with SAP Sybase IQ procedures before using the procedure in Interactive SQL. To compare, use the command:

sp_helptext 'owner.procedure_name'

For system stored procedures delivered by Sybase, the owner is always dbo. To see the text of a stored procedure of the same name owned by a different user, you must specify that user, for example:

sp_helptext 'myname.myprocedure'