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, 2104🔥, 0💬
Popular Posts:
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...