Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

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>