oracle_security_user_role_creation

Oracle Security & 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;

Create role and assign privileges on objects :

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

  • oracle_security_user_role_creation.txt
  • Last modified: 2019/10/18 20:04
  • by 127.0.0.1