Chapter 17: Managing User Permissions

Reporting on permissions

Table 17-6 lists the system procedures for reporting information about proxies, object creation, and object access permissions:

**Table 17-6: System procedures for reporting on permissions**
To report information on	Use
Proxies	system tables
Users and processes	sp_who
Permissions on database objects or users	sp_helprotect
Permissions on specific tables	sp_table_privileges
Permissions on specific columns in a table	sp_column_privileges