ListPrivilegeColumns Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The ListPrivilegeColumns method returns a SQLObjectList object that enumerates the columns of a table or view exposing update or query permission for a Microsoft SQL Server database user or role.
Syntax
object.ListPrivilegeColumns()asSQLObjectList
Parts
- object
Expression that evaluates to an object in the Applies To list.
Prototype (C/C++)
HRESULT ListPrivilegeColumns(
LPSQLDMOCOLUMNLIST* ppList);
Returns
A SQLObjectList object that contains 0 or more Column objects.
Remarks
Use the ListPrivilegeColumns method when the Permission object enumerates a grant for SELECT or UPDATE statement execution privilege on a table or view.
The method returns an empty SQLObjectList object when the referenced permission is granted on all columns in the table or view, or the Permission object enumerates any other type of privilege, such as execution permission for a stored procedure.