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