Software QA (13)
SQL Server (1)
What Privilege Is Needed for a User to Connect to Oracle Server
What Privilege Is Needed for a User to Connect to Oracle Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
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.
2007-05-02, 4621👍, 0💬
Can we get a strongly typed resource class rather than using resource manager? In the previous quest...
What is the FP per day in your current company?
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...
How To View All Columns in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If ...
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...