Collections:
Privilege Needed to Connect to Oracle Server in Oracle
What Privilege Is Needed for a User to Connect to Oracle Server in Oracle?
✍: FYIcenter.com
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.
⇒ Grant CREATE SESSION Privilege in Oracle
⇐ Delete a User Account in Oracle
2019-07-09, 1629🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......