Enable/Disable Restricted Sessions in AWS Oracle RDS

How to enable and disable the restricted sessions in Oracle RDS AWS

Check the logins details as follows:

SELECT LOGINS FROM V$INSTANCE;
 
LOGINS
-------
ALLOWED

Enable the Restricted sessions for Oracle RDS AWS

EXEC rdsadmin.rdsadmin_util.restricted_session(p_enable => true);

Verify that the database is now restricted

SELECT LOGINS FROM V$INSTANCE;
 
LOGINS
----------
RESTRICTED

Disable restricted sessions

EXEC rdsadmin.rdsadmin_util.restricted_session(p_enable => false);

Verify the database is in allowed state:

SELECT LOGINS FROM V$INSTANCE;
 
LOGINS
-------
ALLOWED
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply