|
Introduction to Rights and Permissions |
|
|
|
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.
|
Besides granting or denying permissions to an account,
you can give an account the ability to grant or deny permissions to other
accounts. To do this visually, open the Database Properties for the database
you want to work on. In the Users or Roles section, select the user. In the
Persmissions, use the check boxes in the With Grant column.
The formula to programmatically give an account the
ability to grant or deny permissions to other accounts is:
GRANT Permission1,Permission2, Permission_n
TO Login1, Login2, Login_n
WITH GRANT OPTION
This follows the same formula as the GRANT
right we saw earlier. You must just add the WITH GRANT OPTION
expression.
