Privilege Needed to Connect to Oracle Server in Oracle

Q

What Privilege Is Needed for a User to Connect to Oracle Server in Oracle?

✍: FYIcenter.com

A

Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection:

>.\bin\sqlplus /nolog
SQL> connect SYSTEM/fyicenter

SQL> CREATE USER DEV IDENTIFIED BY developer ACCOUNT UNLOCK;
User created.

SQL> disconnect
SQL> CONNECT DEV/developer
ORA-01045: user DEV lacks CREATE SESSION privilege;
  logon denied

Oracle error message is pretty clear.

 

⇒Managing Oracle User Accounts, Schema and Privileges

⇒⇒Oracle Database Tutorials

2016-10-17, 373👍, 0💬

General MySQL Oracle SQL Server