This topic has not yet been rated - Rate this topic

DatabaseRole.EnumObjectPermissions Method (String, ObjectPermissionSet)

SQL Server 2012

SQL Server 2005

Returns a list of object permissions assigned to the referenced database role for the specified member of the role and for the specified set of permissions.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

public ObjectPermissionInfo[] EnumObjectPermissions(
	string granteeName,
	ObjectPermissionSet permissions
)

Parameters

granteeName: Type: System.String
A String value that specifies the name of the database role member.

permissions: Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
An ObjectPermissionSet that specifies the set of object permissions.

Return Value

Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[]
An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

DatabaseRole.EnumObjectPermissions Method (String, ObjectPermissionSet)

Parameters

Return Value

Implements

Reference

Other Resources

Community Additions