Switching to Restricted Session Mode (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Switching to Restricted Session Mode

Use

You can operate the Oracle database in restricted session mode. This means that only users with a specific access privilege – usually database administrators – can log onto the database.

You can use SAPDBA to check the current database mode and change it if necessary.

Prerequisites

You have configured and started SAPDBA. Refer to Getting Started with SAPDBA.

For more information on how to start up the database in restricted mode, see Starting up the Oracle Database System.

Procedure

Choose User and Security ® Restricted Mode.

SAPDBA displays the current database mode, normally RESTRICTED MODE: Disabled.

Choose Enable restricted mode to change the database mode.

SAPDBA switches the database to restricted mode, first checking whether the SAPR3 user is logged on to the database and warning you if so.

Note

When you exit SAPDBA, it checks the database mode. If you have been working in restricted session mode, SAPDBA asks if you want to change the mode to normal, so enabling other users to log onto the database.