ListPermissions Method (SQL-DMO)

The ListPermissions method returns a SQLObjectList object enumerating object access privilege for Microsoft® SQL Server™ database roles and users.

Applies To
DBObject Object Table Object
StoredProcedure Object View Object

Syntax

object.ListPermissions( [ 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 for DBObject, Table, and View objects. All applicable object privilege.
SQLDMOPriv_Delete 8 List object enumerates accounts granted permission to execute a DELETE statement against the referenced table or view.
SQLDMOPriv_Execute 16 Default for the StoredProcedure object. List object enumerates accounts granted EXECUTE permission on the referenced stored procedure.
SQLDMOPriv_Insert 2 List object enumerates accounts granted permission to execute an INSERT statement against the referenced table or view.
SQLDMOPriv_References 32 List object enumerates accounts that can use the referenced table in declarative referential integrity constraints.
SQLDMOPriv_Select 1 List object enumerates accounts granted permission to execute a SELECT statement against the referenced table or view.
SQLDMOPriv_Update 4 List object enumerates accounts granted permission to execute an UPDATE statement against the referenced table or view.

Returns

A SQLObjectList object containing 0 or more Permission objects.

Remarks

The ListPermissions 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 ListPermissions method.

Prototype (C/C++)

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

HRESULT ListPermissions(
LPSQLDMOPERMISSIONLIST* ppList,
SQLDMO_PRIVILEGE_TYPE lPrivilegeTypes = SQLDMOPriv_Execute);

  


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