Granting Privileges to Roles and Users

Typically, privileges are granted to roles which are in turn granted to users. Privileges can also be granted directly to a user.

• Example of an explicit grant to a User: You can explicitly grant the privilege to insert records into the EMPLOYEES table to the user SCOTT.

• Example of a grant to a Role: You can grant the privilege to insert records into the EMPLOYEES table to the role named CLERK, and, in turn you can grant that role to users SCOTT and HR.

In Visual Studio, you can use the Granting and Revoking Privileges Dialog which allows you to grant or revoke:

• Permissions on one or more database objects to a user or role

• Permissions on one database object to multiple users or roles

• System privileges to multiple users or roles

• A role to multiple users or roles

  See Also

  About Privileges | Grant/Revoke Privileges Dialog