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;

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

Difference: Oracle Session & Oracle Connection
Interacting with an Oracle Database
Difference: PFILE and SPFILE
ORA-00904: invalid identifier
© 2018 ITsiti. All Rights Reserved
Powered by KEEM