User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. To connect to the database a user must be granted the permission to create a session, which is the CREATE SESSION system pr
Permissions are granted by a privileged user (system, for example) using the GRANT statement.
The following example grants the CREATE SESSION permission to jason:

CONNECT system/manager
SQL> CREATE USER jason IDENTIFIED BY pass;
User created.
SQL>
SQL> GRANT CREATE SESSION TO jason;
Grant succeeded.
SQL>
SQL> DROP USER jason;
User dropped.