Posted By

kamilch on 08/06/09


Tagged

Oracle


Versions (?)

Create new Oracle user


 / Published in: PL/SQL
 

  1. -- creates new user JOHN with 123456 password
  2. -- and grants all privileges to him
  3. CREATE USER JOHN IDENTIFIED BY "123456" DEFAULT tablespace USERS;
  4. GRANT ALL PRIVILEGES TO JOHN;

Report this snippet  

You need to login to post a comment.