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, 1619🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...