System procedures used for security administration

These system procedures are used for:

• Adding, dropping, and reporting on logins on Adaptive Server

• Adding, dropping, and reporting on users, groups, roles, and aliases in a database

• Changing passwords and default databases

• Adding, dropping, and reporting on remote servers that can access the current

• Adding the names of users from remote servers who can access the current Adaptive Server

The procedures in this category are:

• sp_activeroles

• sp_addalias

• sp_addgroup

• sp_addlogin

• sp_adduser

• sp_changegroup

• sp_displaylogin

• sp_displayroles

• sp_dropalias

• sp_dropgroup

• sp_droplogin

• sp_dropuser

• sp_encryption

• sp_errorlog

• sp_helpgroup

• sp_helprotect

• sp_helpuser

• sp_lmconfig

• sp_locklogin

• sp_logintrigger

• sp_modifylogin

• sp_password

• sp_passwordpolicy

• sp_post_xpload

• sp_role

• sp_spaceusage

• sp_tab_suspectptn

• sp_webservices

Additional system procedures are available for Windows. The procedures in this category are:

• sp_grantlogin

• sp_loginconfig

• sp_logininfo

• sp_processmail

• sp_revokelogin