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_helpgroup
sp_helprotect
sp_helpuser
sp_locklogin
sp_modifylogin
sp_password
sp_role
Additional system procedures are available for Windows. The procedures in this category are:
sp_grantlogin
sp_loginconfig
sp_logininfo
sp_processmail
sp_revokelogin
Copyright © 2005. Sybase Inc. All rights reserved. |