Deny Method (Database) (SQL-DMO)

The Deny method negates a granted database permission or a list of granted permissions for one or more Microsoft® SQL Server™ users or roles.

Applies To

Database Object

Syntax

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

Settings
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

Remarks

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.

Prototype (C/C++)

HRESULT Deny(
SQLDMO_PRIVILEGE_TYPE iPrivileges,
SQLDMO_LPCSTR GranteeNames);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.