This content has been marked as final. Show 4 replies
Once you do this, only users granted the "RESTRICTED SESSION" privilege will be able to login.
alter system enable restricted session;
Thanks Marcus for your input..
But won't it block all other sessions to db if users trying to connect different schema??
What happens to sessions who are already connected?
Oh, do you want to stop connections from ONE user/schema ? Sorry, I misunderstood your request. Just lock the account, it will only affect new connections. Be careful though: some applications use multiple connections without you noticing.
P.S.: "enable restricted session" also affects only new connections.
Edited by: Marcus Rangel on Nov 26, 2012 1:38 PM
Thanks Marcus for you valuable inputs...