Server.Revoke Method
Revokes a previously granted set of permissions from a grantee or grantees on the instance of Microsoft SQL Server.
Remarks
Updated text:
The Revoke method has several overloads that give you a choice of whether to revoke one or more permissions from a single grantee or from several grantees. It lets you specify whether the grantee has permission to revoke the permissions from others, and what role the grantee assumes when taking this action. This method also lets you revoke any permissions that the grantee might have granted to other users.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Overload List
| Name | Description |
|---|---|
| Server.Revoke (ServerPermissionSet, String) |
Revokes a previously granted set of permissions from a list of grantees on the instance of Microsoft SQL Server.
|
| Server.Revoke (ServerPermissionSet, String[]) |
Revokes a previously granted set of permissions from a list of grantees on the instance of Microsoft SQL Server.
|
| Server.Revoke (ServerPermissionSet, String, Boolean, Boolean) |
Revokes previously granted permissions from a grantee on the instance of Microsoft SQL Server and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
|
| Server.Revoke (ServerPermissionSet, String[], Boolean, Boolean) |
Revokes previously granted permissions from grantees on the instance of Microsoft SQL Server and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
|
| Server.Revoke (ServerPermissionSet, String, Boolean, Boolean, String) |
Revokes previously granted permissions from a grantee on the instance of Microsoft SQL Server and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.
|
| Server.Revoke (ServerPermissionSet, String[], Boolean, Boolean, String) |
Revokes previously granted permissions from grantees on the instance of Microsoft SQL Server and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.
|
See Also
Reference
Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
How to: Grant Server Permissions in Visual Basic .NET
Granting, Revoking, and Denying Permissions
Managing Servers
Change History
Release |
History |
New content:
|