The Deny method negates a granted database permission or a list of granted permissions for one or more Microsoft® SQL Server™ users or roles.
object.Deny( 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 multistring listing users or roles |
Constant | Value | Description |
---|---|---|
SQLDMOPriv_AllDatabasePrivs | 65408 | Deny all granted database privileges |
SQLDMOPriv_CreateDatabase | 256 | Deny permission to execute the CREATE DATABASE statement |
SQLDMOPriv_CreateDefault | 4096 | Deny permission to execute the CREATE DEFAULT statement |
SQLDMOPriv_CreateProcedure | 1024 | Deny permission to execute the CREATE PROCEDURE statement |
SQLDMOPriv_CreateRule | 16384 | Deny permission to execute the CREATE RULE statement |
SQLDMOPriv_CreateTable | 128 | Deny permission to execute the CREATE TABLE statement |
SQLDMOPriv_CreateView | 512 | Deny permission to execute the CREATE VIEW statement |
SQLDMOPriv_DumpDatabase | 2048 | Deny permission to back up a database |
SQLDMOPriv_DumpTable | 32768 | Maintained for compatibility with previous versions of SQL-DMO |
SQLDMOPriv_DumpTransaction | 8192 | Deny permission to backup a database transaction log |
Denying permissions to database users and roles by using the Deny method of the Database object requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the system-defined role sysadmin.
HRESULT Deny(
SQLDMO_PRIVILEGE_TYPE iPrivileges,
SQLDMO_LPCSTR GranteeNames);