Oracle - Grant CREATE SESSION Privilege in Oracle

Grant CREATE SESSION Privilege in Oracle

Q

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

✍: FYIcenter.com

A

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:

>.\bin\sqlplus /nolog
SQL> connect SYSTEM/fyicenter

SQL> GRANT CREATE SESSION TO dev;
Grant succeeded.

SQL> disconnect
SQL> CONNECT DEV/developer
Connected.

⇒Managing Oracle User Accounts, Schema and Privileges

⇒⇒Oracle Database Tutorials

2016-10-16, 340👍, 0💬

Popular Posts:

Downloading and Inst...

Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

Getting Year, Month ...

How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

Selecting Some Speci...

How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...