Basic Oracle Concepts and Programming Question:
Download Questions PDF

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

Answer:

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

>.insqlplus /nolog
SQL> connect SYSTEM/globalguideline

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.

Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Delete a User Account in Oracle?How To Grant CREATE SESSION Privilege to a User in Oracle?