Collections:
Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle?
✍: FYIcenter.com
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.
⇒ Revoke CREATE SESSION Privilege in Oracle
⇐ Privilege Needed to Connect to Oracle Server in Oracle
2019-07-09, 1575🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...