Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

Getting information about users

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

**Table 14-9: 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