|
|
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.
|
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
