Share via


DatabaseRole.Revoke Method (ObjectPermissionSet, String)

Revokes a previously granted set of permissions from a grantee on the database role.

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

Syntax

'Declaration
Public Sub Revoke ( _
    permission As ObjectPermissionSet, _
    granteeName As String _
)
'Usage
Dim instance As DatabaseRole 
Dim permission As ObjectPermissionSet 
Dim granteeName As String

instance.Revoke(permission, granteeName)
public void Revoke(
    ObjectPermissionSet permission,
    string granteeName
)
public:
virtual void Revoke(
    ObjectPermissionSet^ permission, 
    String^ granteeName
) sealed
abstract Revoke : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit  
override Revoke : 
        permission:ObjectPermissionSet * 
        granteeName:string -> unit
public final function Revoke(
    permission : ObjectPermissionSet, 
    granteeName : String
)

Parameters

  • granteeName
    Type: System.String
    A String value that specifies a grantee to be revoked the set of permissions.

Implements

IObjectPermission.Revoke(ObjectPermissionSet, String)

Examples

Granting, Revoking, and Denying Permissions

See Also

Reference

DatabaseRole Class

Revoke Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Managing Users, Roles, and Logins

Database-Level Roles

CREATE ROLE (Transact-SQL)