Show pageOld revisionsBacklinksODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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> oracle_security_user_role_creation.txt Last modified: 2019/10/18 20:04by 127.0.0.1