Use sp_column_privileges to return information about permissions on columns in a table. The syntax is:
sp_column_privileges table_name [, table_owner [, table_qualifier [, column_name]]]
where:
table_name – is the name of the table.
table_owner – can be used to specify the name of the table owner, if it is not “dbo” or the user executing sp_column_privileges.
table_qualifier – is the name of the current database.
column_name – is the name of the column on which you want to see permissions information.
Use null for parameters that you want to skip.
For example, the following statement:
sp_column_privileges publishers, null, null, pub_id
returns information about the pub_id column of the publishers table. For more information about the output of sp_column_privileges, see the Reference Manual.
