oracle_security_user_role_creation

Oracle Security & Users

Users

Create new user :

1
2
3
4
5
6
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 :

1
2
3
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