Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Grant CREATE SESSION Privilege to a User in Oracle?

If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server:

>.insqlplus /nolog

SQL> connect SYSTEM/globalguideline

SQL> GRANT CREATE SESSION TO dev;

Grant succeeded.

SQL> disconnect

SQL> CONNECT DEV/developer

Connected.

 163 views

More Questions for you: