Table of Contents

Oracle Security & Users

Users

Create new user :

CREATE USER '&USER' IDENTIFIED BY '&PASSWORD'
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS, QUOTA UNLIMITED ON EXAMPLE
PROFILE DEFAULT 
PASSWORD EXPIRE
ACCOUNT UNLOCK;

Roles

Create role and assign privileges on objects :

create role <ROLENAME>;
grant select on <OWNER>.<OBJECT>;
grant <ROLENAME> to <GRANTEE>;