GRANT CREATE SESSION TO newUserName in order to log in : SESSION privileges « User Previliege « Oracle PL / SQL






GRANT CREATE SESSION TO newUserName in order to log in

 
SQL>
SQL> CREATE USER newUserName IDENTIFIED BY password;

User created.

SQL>
SQL> SELECT default_tablespace, temporary_tablespace
  2  FROM dba_users
  3  WHERE username='NEWUSERNAME';

DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYSTEM                         TEMP

SQL>
-- sqlplus newUserName/password

SQL> GRANT CREATE SESSION TO newUserName;

Grant succeeded.

SQL>
SQL> DROP USER newUserName;

User dropped.

SQL>

 








Related examples in the same category

1.Grant CREATE SESSION privilege to a user, hr, allowing hr to log on to an Oracle database
2.grant a system privilege to PUBLIC