다음을 통해 공유


ListObjectPermissions Method

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The ListObjectPermissions method returns a SQLObjectList object that enumerates object access privilege for one or more Microsoft SQL Server security accounts.

구문

object
.ListObjectPermissions( [ Privilege ] )as SQLObjectList

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Privilege
    Optional. Constrains the list to members that enumerates object access permissions as described in Settings.

Prototype (C/C++)

HRESULT ListObjectPermissions(
LPSQLDMOPERMISSIONLIST* ppList,
SQLDMO_PRIVILEGE_TYPE lPrivilegeTypes = SQLDMOPriv_AllObjectPrivs);

Settings

When setting the Privilege argument to override default behavior, indicate more than a single permission by combining values using an OR logical operator. Set Privilege by using these SQLDMO_PRIVILEGE_TYPE values.

Constant Value Description

SQLDMOPriv_/AllObjectPrivs

63

Default. All applicable object privilege.

SQLDMOPriv_Delete

8

List object enumerates accounts and those tables or views against which permission is granted to execute a DELETE statement.

SQLDMOPriv_Execute

16

List object enumerates accounts and those stored procedures for which permission is granted to execute an EXECUTE statement.

SQLDMOPriv_Insert

2

List object enumerates accounts and those tables or views against which permission is granted to execute an INSERT statement.

SQLDMOPriv_References

32

List object enumerates accounts, and those tables that the account can reference, in declarative referential integrity constraints.

SQLDMOPriv_Select

1

List object enumerates accounts and those tables or views against which permission is granted to execute a SELECT statement.

SQLDMOPriv_Update

4

List object enumerates accounts and those tables or views against which permission is granted to execute an UPDATE statement.

Returns

A SQLObjectList object that contains 0 or more Permission objects

주의

The ListObjectPermissions method enumerates object access permissions granted explicitly.

SQL Server server and database roles assign privilege by granting statement execution permissions implicitly. Implicit grants are not enumerated by the ListObjectPermissions method.

Applies To:

Database Object

User Object

DatabaseRole Object