User Previliege Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. User Previliege
  4. Assign CONNECT and RESOURCE Roles
SQL>
SQL> CREATE USER Alice IDENTIFIED BY simplepassword;
User created.
SQL>
SQL> GRANT CONNECT, RESOURCE to Alice;
Grant succeeded.
SQL>
SQL>
SQL> drop user alice;
User dropped.
SQL>
SQL>