Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Grant connect and resource permission to a user

SQL> SQL> CREATE USER tempc IDENTIFIED BY tempc; User created. SQL> GRANT CONNECT, RESOURCE to tempc; Grant succeeded. SQL> drop user tempc; User dropped.