Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Grant connect permission to a user

SQL> SQL> CREATE USER tempb IDENTIFIED BY tempb; User created. SQL> SQL> GRANT CONNECT TO tempb; Grant succeeded. SQL> SQL> drop user tempb; User dropped.