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. It 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, the following statement:
sp_table_privileges titles
returns information about all permissions granted on the titles table. For more information about the output of sp_table_privileges see the Reference Manual.
