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>;