The Revoke method undoes a grant or deny of database permissions for one or more Microsoft® SQL Server™ users or roles.
object.Revoke( Privilege , GranteeNames )
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| Privilege | Long integer specifying one or more database privileges as described in Settings |
| GranteeNames | SQL-DMO multi-string listing users or roles |
Set the Privilege argument by using these values. To specify more than a single permission, combine values by using an Or.
| Constant | Value | Description |
|---|---|---|
| SQLDMOPriv_AllDatabasePrivs | 65408 | Revoke all granted or denied database privilege. |
| SQLDMOPriv_CreateDatabase | 256 | Revoke granted or denied permission to execute a CREATE DATABASE statement. |
| SQLDMOPriv_CreateDefault | 4096 | Revoke granted or denied permission to execute a CREATE DEFAULT statement. |
| SQLDMOPriv_CreateProcedure | 1024 | Revoke granted or denied permission to execute a CREATE PROCEDURE statement. |
| SQLDMOPriv_CreateRule | 16384 | Revoke granted or denied permission to execute a CREATE RULE statement. |
| SQLDMOPriv_CreateTable | 128 | Revoke granted or denied permission to execute a CREATE TABLE statement. |
| SQLDMOPriv_CreateView | 512 | Revoke granted or denied permission to execute a CREATE VIEW statement. |
| SQLDMOPriv_DumpDatabase | 2048 | Revoke granted or denied permission to back up the database. |
| SQLDMOPriv_DumpTable | 32768 | Maintained for compatibility with previous versions of SQL-DMO. |
| SQLDMOPriv_DumpTransaction | 8192 | Revoke granted or denied permission to back up the database transaction log. |
Revoking granted or denied permissions to database users and roles by using the Revoke method of the Database object requires appropriate privilege. The Microsoft® SQL Server™ login used for SQLServer object connection must be a member of the system-defined role sysadmin.
HRESULT Revoke(
SQLDMO_PRIVILEGE_TYPE iPrivileges,
SQLDMO_LPCSTR GranteeNames);