Home

Databases Permissions: WITH GRANT

 

Introduction to Rights and Permissions

 

Overview

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.

Extending Permissions

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.

   
     
 

Home Copyright © 2007-2011 FunctionX.com Home