Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

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.