keky

Create new database user

Mar 14th, 2015
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.36 KB | None | 0 0
  1. CREATE USER keky IDENTIFIED BY linkinpark
  2. DEFAULT tablespace USERS
  3. TEMPORARY tablespace TEMP;
  4. GRANT CONNECT, resource TO keky;
  5. GRANT CREATE TABLE TO keky;
  6. GRANT CREATE VIEW TO keky;
  7. GRANT CREATE PROCEDURE TO keky;
  8. GRANT CREATE synonym TO keky;
  9. GRANT CREATE SEQUENCE TO keky;
  10. GRANT SELECT ON dba_rollback_segs TO keky;
  11. GRANT SELECT ON dba_segments TO keky;
Advertisement
Add Comment
Please, Sign In to add comment