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, this statement returns information about the pub_id column of the publishers table:
sp_column_privileges publishers, null, null, pub_id
For more information about the output of sp_column_privileges, see the Reference Manual.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
