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
EMPLOYEEStable to the userSCOTT. -
Example of a grant to a Role: You can grant the privilege to insert records into the
EMPLOYEEStable to the role namedCLERK, and, in turn you can grant that role to usersSCOTTandHR.
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