create role and give privileges to it

[edson.amorim]

Dear colleague,

How do I see the attributes or privileges of a role? How to create these privileges in the role?

Sincerely,

[pauloaleo]

See DBMS_Rule_ADM documentation.

is with her that you contro rules, privileges, etc.

Hugs

[CarlosStetner]

Friend to give Grant in role is the same as Grant to User.

Grant Select on Table to Grant

To know the Grants You can look at DBA_ROLE_PRIVS

[igor.rmarinho]

An example:

Select all

CREATE ROLE RH; 
GRANT CONNECT TO RH; 
 
GRANT SELECT,UPDATE ON RH_EMP TO RH; 
 
CREATE ROLE HR_GERERENTE IDENTIFIED BY A123; -- CRIA UMA ROLE COM SENHA 
 
GRANT INSERT, DELETE  ON RH_EM TO RH_GERENTE; 
 
GRANT RH TO RH_GERENTE;

In this case the Role rh_gherente has the privilegio of the Rhol + AS which were only assigned to it