DatabaseRole.EnumObjectPermissions DatabaseRole.EnumObjectPermissions DatabaseRole.EnumObjectPermissions Method

Definition

Returns a list of object permissions assigned to the database role.

Overloads

EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet)

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.

EnumObjectPermissions() EnumObjectPermissions() EnumObjectPermissions()

Returns a list of object permissions assigned to the referenced database role.

EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet)

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

EnumObjectPermissions(String) EnumObjectPermissions(String) EnumObjectPermissions(String)

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

EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet) EnumObjectPermissions(String, ObjectPermissionSet)

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.

public:
 virtual cli::array <Microsoft::SqlServer::Management::Smo::ObjectPermissionInfo ^> ^ EnumObjectPermissions(System::String ^ granteeName, Microsoft::SqlServer::Management::Smo::ObjectPermissionSet ^ permissions);
public Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[] EnumObjectPermissions (string granteeName, Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions);
Public Function EnumObjectPermissions (granteeName As String, permissions As ObjectPermissionSet) As ObjectPermissionInfo()
Parameters
granteeName
String String String

A String value that specifies the name of the database role member.

permissions
ObjectPermissionSet ObjectPermissionSet ObjectPermissionSet

An ObjectPermissionSet that specifies the set of object permissions.

Returns

An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.

Implements

Examples

Managing Users, Roles, and Logins

EnumObjectPermissions() EnumObjectPermissions() EnumObjectPermissions()

Returns a list of object permissions assigned to the referenced database role.

public:
 virtual cli::array <Microsoft::SqlServer::Management::Smo::ObjectPermissionInfo ^> ^ EnumObjectPermissions();
public Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[] EnumObjectPermissions ();
Public Function EnumObjectPermissions () As ObjectPermissionInfo()
Returns

An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.

Implements

Examples

Managing Users, Roles, and Logins

EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet) EnumObjectPermissions(ObjectPermissionSet)

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

public:
 virtual cli::array <Microsoft::SqlServer::Management::Smo::ObjectPermissionInfo ^> ^ EnumObjectPermissions(Microsoft::SqlServer::Management::Smo::ObjectPermissionSet ^ permissions);
public Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[] EnumObjectPermissions (Microsoft.SqlServer.Management.Smo.ObjectPermissionSet permissions);
Public Function EnumObjectPermissions (permissions As ObjectPermissionSet) As ObjectPermissionInfo()
Parameters
permissions
ObjectPermissionSet ObjectPermissionSet ObjectPermissionSet

An ObjectPermissionSet that specifies the set of object permissions.

Returns

An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.

Implements

Examples

Managing Users, Roles, and Logins

EnumObjectPermissions(String) EnumObjectPermissions(String) EnumObjectPermissions(String)

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

public:
 virtual cli::array <Microsoft::SqlServer::Management::Smo::ObjectPermissionInfo ^> ^ EnumObjectPermissions(System::String ^ granteeName);
public Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[] EnumObjectPermissions (string granteeName);
Public Function EnumObjectPermissions (granteeName As String) As ObjectPermissionInfo()
Parameters
granteeName
String String String

A String value that specifies the name of the database role member.

Returns

An array of ObjectPermissionInfo object values that contain information about object permissions assigned to the database role.

Implements

Examples

Managing Users, Roles, and Logins

Applies to