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.