Disable Restricted Session

How do you get back into SQLPlus to disable restricted session if you enabled.

duke147
Profile Answers by duke147 Questions by duke147
Sep 16th, 2008
4
8856

Showing Answers 1 - 4 of 4 Answers

hamsatharini
Profile Answers by hamsatharini

Sep 26th, 2008

Alter system disable restricted session;

oraclebadshah
Profile Answers by oraclebadshah

Sep 27th, 2008

"When database is in restricted mode only users who have restricted permissions can log on to database"
To disable it
ALTER SYSTEM DISABLE RESTRICTED SESSION

Lanie Acosta

Aug 27th, 2015

Yes

sandeep

Jun 30th, 2017

First of all login with sysdba,
Use the query..
Alter system disable restricted session;
this query disable restricted session