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, 304👍, 0💬

Popular Posts:

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

Transaction Manageme...

Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...

Formatting Time Zone...

How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...