Reporting on permissions

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

Table 11-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