DATABASE ROLES

create role r1;

Role created.

0.00 seconds


grant create session, create table , create database link to r1

Statement processed.

0.03 seconds
select * from role_sys_privs where role='r1'

no data found
select * from role_sys_privs where role='R1'

ROLE PRIVILEGE ADMIN_OPTION
R1 CREATE SESSION NO
R1 CREATE TABLE NO
R1 CREATE DATABASE LINK NO


select * from role_sys_privs where role='CONNECT'

ROLE PRIVILEGE ADMIN_OPTION
CONNECT CREATE SESSION NO
3 rows returned in 0.04 seconds         CSV Export
create user user1 identified by user1 default tablespace userdata;

User created.

0.02 seconds


grant r1 to user1
Statement processed.

0.00 seconds

u1>set sqlp user1>
user1>conn user1/user1
Connected.


grant dba to user1


Statement processed.

0.01 seconds

user1>select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE DATABASE LINK


user1>select * from session_roles;

ROLE
------------------------------
R1
alter system set resource_limit=true;