Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

CREATE USER userName IDENTIFIED BY password and grant permission

SQL>  CREATE USER user1 IDENTIFIED BY pass1; User created. SQL> CREATE USER user2 IDENTIFIED BY pass2; User created. SQL> GRANT CREATE SESSION TO user1, user2; Grant succeeded. SQL> SQL> DROP USER user1; User dropped. SQL> DROP USER user2; User dropped.