The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_column_privileges_rowset(nvarchar @table_name, nvarchar @table_schema
, nvarchar @column_name
, nvarchar @grantor
, nvarchar @grantee)
MetaData:
create procedure sys.sp_column_privileges_rowset ( @table_name sysname, @table_schema sysname = null, @column_name sysname = null, @grantor sysname = null, @grantee sysname = null ) as select -- Rows for explicitly set database permissions. GRANTOR = s_cpsv.GRANTOR, GRANTEE = s_cpsv.GRANTEE, TABLE_CATALOG = s_cpsv.TABLE_CATALOG, TABLE_SCHEMA = s_cpsv.TABLE_SCHEMA, TABLE_NAME = s_cpsv.TABLE_NAME, COLUMN_NAME = s_cpsv.COLUMN_NAME, COLUMN_GUID = s_cpsv.COLUMN_GUID, COLUMN_PROPID = s_cpsv.COLUMN_PROPID, PRIVILEGE_TYPE = s_cpsv.PRIVILEGE_TYPE, IS_GRANTABLE = s_cpsv.IS_GRANTABLE from sys.spt_column_privileges_set_view s_cpsv where ( (@table_schema is null and s_cpsv.TABLE_NAME = @table_name) or s_cpsv.object_id = object_id(quotename(@table_schema) + '.' + quotename(@table_name)) ) and (@column_name is null or @column_name = s_cpsv.COLUMN_NAME) and (@grantor is null or @grantor = s_cpsv.GRANTOR) and (@grantee is null or @grantee = s_cpsv.GRANTEE) union all select -- Add rows for table owner GRANTOR = s_cpov.GRANTOR, GRANTEE = s_cpov.GRANTEE, TABLE_CATALOG = s_cpov.TABLE_CATALOG, TABLE_SCHEMA = s_cpov.TABLE_SCHEMA, TABLE_NAME = s_cpov.TABLE_NAME, COLUMN_NAME = s_cpov.COLUMN_NAME, COLUMN_GUID = s_cpov.COLUMN_GUID, COLUMN_PROPID = s_cpov.COLUMN_PROPID, PRIVILEGE_TYPE = s_cpov.PRIVILEGE_TYPE, IS_GRANTABLE = s_cpov.IS_GRANTABLE from sys.spt_column_privileges_owner_view s_cpov where ( (@table_schema is null and s_cpov.TABLE_NAME = @table_name) or s_cpov.object_id = object_id(quotename(@table_schema) + '.' + quotename(@table_name)) ) and (@column_name is null or @column_name = s_cpov.COLUMN_NAME) and (@grantor is null or @grantor = s_cpov.GRANTOR) and (@grantee is null or @grantee = s_cpov.GRANTEE) order by 4, 5, 6, 9, 1, 2
No comments:
Post a Comment