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 Adaptive Server
Adding the names of users from remote servers who can access the current Adaptive Server
The procedures in this category are:
sp_activeroles |
sp_changegroup |
sp_droplogin |
sp_locklogin |
sp_addalias |
sp_displaylogin |
sp_dropuser |
sp_modifylogin |
sp_addgroup |
sp_displayroles |
sp_helpgroup |
sp_password |
sp_addlogin |
sp_dropalias |
sp_helprotect |
sp_role |
sp_adduser |
sp_dropgroup |
sp_helpuser |
Additional system procedures are available for Windows NT. The procedures in this category are:
sp_grantlogin |
sp_logininfo |
sp_revokelogin |
sp_loginconfig |
sp_processmail |
