Collections:
Revoke CREATE SESSION Privilege in Oracle
How To Revoke CREATE SESSION Privilege from a User in Oracle?
✍: FYIcenter.com
If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script:
>.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL> REVOKE CREATE SESSION FROM dev; Revoke succeeded. SQL> GRANT CREATE SESSION TO dev; Grant succeeded.
This script restored the CREATE SESSION privilege to user "dev", so you can continue other example scripts below.
⇒ Lock and Unlock a User Account in Oracle
⇐ Grant CREATE SESSION Privilege in Oracle
2019-07-09, 1611🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...