User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. 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.