共用方式為


ListPrivilegeColumns Method

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

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.

語法

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.

備註

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.

Applies To: