Table 10-9 lists procedures you can use to obtain information about users, groups, and current Adaptive Server usage.
Task |
Procedure |
---|---|
Report current Adaptive Server users and processes |
sp_who |
Display information about login accounts |
sp_displaylogin |
Report users and aliases in a database |
sp_helpuser |
Report groups within a database |
sp_helpgroup |