User.EnumObjectPermissions Method (String, ObjectPermissionSet)

Enumerates a list of object permissions for a specified grantee and a specified permission on the database user.

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

Syntax

'Bildirim
Public Function EnumObjectPermissions ( _
    granteeName As String, _
    permissions As ObjectPermissionSet _
) As ObjectPermissionInfo()
'Kullanım
Dim instance As User
Dim granteeName As String
Dim permissions As ObjectPermissionSet
Dim returnValue As ObjectPermissionInfo()

returnValue = instance.EnumObjectPermissions(granteeName, _
    permissions)

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

public:
virtual array<ObjectPermissionInfo^>^ EnumObjectPermissions(
    String^ granteeName, 
    ObjectPermissionSet^ permissions
) sealed

abstract EnumObjectPermissions : 
        granteeName:string * 
        permissions:ObjectPermissionSet -> ObjectPermissionInfo[] 
override EnumObjectPermissions : 
        granteeName:string * 
        permissions:ObjectPermissionSet -> ObjectPermissionInfo[] 

public final function EnumObjectPermissions(
    granteeName : String, 
    permissions : ObjectPermissionSet
) : ObjectPermissionInfo[]

Parameters

• granteeName
  Type: System.String
  A String value that specifies the grantee.

• permissions
  Type: Microsoft.SqlServer.Management.Smo.ObjectPermissionSet
  An ObjectPermissionSet object value that specifies the permission.

Return Value

Type: array<Microsoft.SqlServer.Management.Smo.ObjectPermissionInfo[]
An array of ObjectPermissionInfo objects that contains object permission information for the specified grantee and permission on the database user.

Implements

IObjectPermission.EnumObjectPermissions(String, ObjectPermissionSet)

Examples

Managing Users, Roles, and Logins

See Also

Reference

User Class

EnumObjectPermissions Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Principals (Database Engine)

CREATE USER (Transact-SQL)