Monthly Archives: May 2016

ORACLE TIPS

USER/SCHEMA: – Create new user CREATE USER USRPPTEST1 IDENTIFIED BY VALUES ‘USRPPTEST1’ DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT DBA TO USRPPTEST1; GRANT CONNECT TO USRPPTEST1; GRANT RESOURCE TO USRPPTEST1; ALTER USER USRPPTEST1 DEFAULT ROLE ALL; GRANT UNLIMITED TABLESPACE TO USRPPTEST1; – Add privileges to new user GRANT CREATE SESSION TO […]