Restricting Access to the Oracle Database



Share this article :

You can start an instance and mount and open a database in restricted mode so that the database is available only to administrative personnel (not general database users). Typically, all users with the CREATE SESSION system privilege can connect to an open database. Opening a database in restricted mode allows database access only to users with both the CREATE SESSION and RESTRICTED SESSION system privilege. Only database administrators should have the RESTRICTED SESSION system privilege.

During Database STARTUP

startup RESTRICT

During Database OPEN

alter system ENABLE RESTRICTED session;

Note:
To place an instance in restricted mode, use the SQL statement ALTER SYSTEM with the ENABLE RESTRICTED SESSION clause. After placing an instance in restricted mode, you should consider killing all current user sessions before performing any administrative tasks.

Disable restricted mode

alter system DISABLE RESTRICTED session;

Related posts

Oracle Database Server Structures
Oracle Database Process Architecture
Find the Location of Oracle SPFILE
Get the List of Oracle Ports Component
© 2017 ITsiti. All Rights Reserved
Powered by KEEM