====== Oracle Security & Users ======

===== Users =====
**Create new user :**
<sxh sql>
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;
</sxh>

===== Roles =====

**Create role and assign privileges on objects :**
<sxh sql>
create role <ROLENAME>;
grant select on <OWNER>.<OBJECT>;
grant <ROLENAME> to <GRANTEE>;
</sxh>