Restricted Mode in Oracle Database

Restricted Mode

Instance is available only to users with "restricted session" privilege.

/* startup in restricted mode */   

STARTUP RESTRICT


/* restrict an instance that is already running */

ALTER SYSTEM ENABLE RESTRICTED SESSION