ListObjectPermissions Method (SQL-DMO)

The ListObjectPermissions method returns a SQLObjectList object enumerating object access privilege for one or more Microsoft® SQL Server™ security accounts.

Applies To
Database Object User Object
DatabaseRole Object  

Syntax

object.ListObjectPermissions( [ Privilege ] ) as SQLObjectList

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

Settings

When setting the Privilege argument to override default behavior, indicate more than a single permission by combining values using an Or.

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 containing 0 or more Permission objects.

Remarks

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.

Prototype (C/C++)

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

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.