diakogiannis

Create Schema in Oracle

Nov 16th, 2017
291
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD>;
  2. GRANT CONNECT TO <USERNAME>;
  3. GRANT CREATE SESSION TO <USERNAME> WITH ADMIN OPTION;
  4. GRANT UNLIMITED TABLESPACE TO <USERNAME>;
  5. GRANT RESOURCE TO <USERNAME>;
Advertisement