The ListPrivilegeColumns method returns a SQLObjectList object enumerating the columns of a table or view exposing update or query permission for a Microsoft® SQL Server™ database user or role.
object.ListPrivilegeColumns( ) as SQLObjectList
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
A SQLObjectList object containing 0 or more Column objects.
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.
HRESULT ListPrivilegeColumns(
LPSQLDMOCOLUMNLIST* ppList);