Oracle - Privilege Needed to Connect to Oracle Server in Oracle

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, 337👍, 0💬

Popular Posts:

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...

Ending Stored Proced...

How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...

CONTINUE to Next Loo...

How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...