Getting information about users

Table 3-6 lists procedures you can use to obtain information about users, groups, and current Adaptive Server usage.

Table 3-6: Reporting information about Adaptive Server users and groups

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