Grant Privileges To a Role
GRANT create table, create view TO manager; Grant succeeded.
SQL | Creating Roles
A role is created to ease the setup and maintenance of the security model. It is a named group of related privileges that can be granted to the user. When there are many users in a database it becomes difficult to grant or revoke privileges to users. Therefore, if you define roles:
- You can grant or revoke privileges to users, thereby automatically granting or revoking privileges.
- You can either create Roles or use the system roles pre-defined.
Some of the privileges granted to the system roles are as given below:
System Roles | Privileges Granted to the Role |
---|---|
Connect | Create table, Create view, Create synonym, Create sequence, Create session, etc. |
Resource | Create Procedure, Create Sequence, Create Table, Create Trigger etc. The primary usage of the Resource role is to restrict access to database objects. |
DBA | All system privileges |
Contact Us