Deny Method (Table, View) (SQL-DMO)

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

Applies To
Table Object View Object

Syntax

object.Deny( Privilege , GranteeNames , [ ColumnNames ] ,
[ GrantGrant ] )

Part Description
object Expression that evaluates to an object in the Applies To list.
Privilege Long integer specifying one or more table privileges as described in Settings.
GranteeNames SQL-DMO multistring listing users or roles.
ColumnNames SQL-DMO multistring listing column names within the table or view. When used, the specified privilege is denied on only the columns named.
GrantGrant When True, the grantee(s) specified are granted the ability to execute the DENY statement referencing the table or view. When False (default), the ability to deny permission is not granted.

Settings
Constant Value Description
SQLDMOPriv_AllObjectPrivs 63 Deny all granted table privileges
SQLDMOPriv_Delete 8 Deny permission to execute the DELETE statement referencing the table or view
SQLDMOPriv_Insert 2 Deny permission to execute the INSERT statement referencing the table or view
SQLDMOPriv_References 32 Deny permission to execute the reference the table in declarative referential integrity constraints established on other tables
SQLDMOPriv_Select 1 Deny permission to execute the SELECT statement referencing the table or view
SQLDMOPriv_Update 4 Deny permission to execute the UPDATE statement referencing the table or view

Remarks

Denying permissions to database users and roles by using the Deny method of the Table or View object requires appropriate privilege. The SQL Server login used for SQLServer object connection must be granted the ability to a execute DENY referencing the database object, the owner of the database object, or a member of a role with greater privilege.

Prototype (C/C++)

HRESULT Deny(
SQLDMO_PRIVILEGE_TYPE iPrivileges,
SQLDMO_LPCSTR GranteeNames,
SQLDMO_LPCSTR ColumnNames = NULL,
BOOL GrantGrant =FALSE);

  


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