Home

The DENY Permission

   

Introduction

A permission is an action that a user is allowed to perform, or is prevented from performing, on a database or on one of its objects.

Denying a Permission

To visually deny one or more permissions, in the Object Explorer, right-click the name of the server and click Properties. In the left frame, click Permissions. In the Logins or Roles list, click the name of the user. Use the options in the Deny column.

The basic formula to programmatically deny one or more permissions is:

DENY Permission1,Permission2, Permission_n
TO Login1, Login2, Login_n

Here is an example:

DENY CREATE ANY DATABASE
TO rkouma;
GO
 
 
     
 

Home Copyright © 2007-2011 FunctionX.com Home