Database Roles:-How we can create & grants the role into oracle database:

Database roles are the set of privileges.

LOGIN with sys user:- Name of Role :'Sachin'

sql>create role sachin;

sql>grant create table,create sequence,create view,create sequence,create procedure to sachin

sql>select * from dba_roles;

sql>desc role_sys_privs;

sql>select role,privilege from role_sys_privs where role='sachin'

ROLE PRIVILEGE

------------------------------ ----------------------------------------

RECOVERY_CATALOG_OWNER CREATE SESSION

RECOVERY_CATALOG_OWNER CREATE TABLE

RECOVERY_CATALOG_OWNER CREATE SEQUENCE

RECOVERY_CATALOG_OWNER CREATE PROCEDURE

RECOVERY_CATALOG_OWNER CREATE VIEW

SYSDBA > select role,privilege from role_sys_privs where role='RECOVERY_CATALOG_OWNER';

ROLE PRIVILEGE

------------------------------ ----------------------------------------

RECOVERY_CATALOG_OWNER CREATE SYNONYM

RECOVERY_CATALOG_OWNER CREATE CLUSTER

RECOVERY_CATALOG_OWNER ALTER SESSION

RECOVERY_CATALOG_OWNER CREATE DATABASE LINK

RECOVERY_CATALOG_OWNER CREATE SESSION

RECOVERY_CATALOG_OWNER CREATE TABLE

RECOVERY_CATALOG_OWNER CREATE SEQUENCE

RECOVERY_CATALOG_OWNER CREATE PROCEDURE

RECOVERY_CATALOG_OWNER CREATE VIEW

RECOVERY_CATALOG_OWNER CREATE TYPE

RECOVERY_CATALOG_OWNER CREATE TRIGGER

11 rows selected.