Table 11-6 lists the system procedures for reporting information about proxies, object creation and object access 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 |