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, 2085🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...