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, 1644🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...