ListPrivilegeColumns Method

SQL-DMO

SQL-DMO

ListPrivilegeColumns Method

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™ 2000 database user or role.

Applies To
Permission Object
Syntax

object.ListPrivilegeColumns( ) as SQLObjectList

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.