Use sp_table_privileges to return permissions information about a specified table. The syntax is:
sp_table_privileges table_name [, table_owner [, table_qualifier]]
where:
table_name – is the name of the table, and is required.
table_owner – can be used to specify the name of the table owner, if it is not “dbo” or the user executing sp_table_privileges.
table_qualifier – is the name of the current database.
Use null for parameters that you want to skip.
For example, this statement returns information about all permissions granted on the titles table:
sp_table_privileges titles
For more information about the output of sp_table_privileges, see the Reference Manual: Procedures.
