Re: why can I logon in restricted mode?

If you can login as normal user, this login must have "restricted session" system privilege. Try to revoke it or create new user without granting restricted session privilege.

You can query system privilege by using dba_sys_privs view.

Ying Lin

"Chuck Lucas" <chuck.lucas_at_mspb.gov> wrote in message news:b35u8i$89g$1_at_ngspool-d02.news.aol.com...
> I'm running Oracle8i on Solaris 8...
>
> Here's the scenario:
>
> I shutdown (normal) the database.
> I mount the database, but not open it.
> I run my RMAN stuff.
>
> Now, at this point, I want to bring the database up (open it) in
restricted
> mode, so I
> can run an export.
>
> I issue (in the order shown):
> alter system enable restricted session;
> alter database <name> open;
>
> Now, when I open another SQL*Plus session, I can log in and do whatever I
> want, i.e. select from tables.
>
> Why, when the database is in restricted mode, can I log in? I'm not
logging
> in with a DBA user account--it's just a "normal" user account. Yet, I can
> still log in.
>
> I don't understand....or does restricted mode just mean that I can't alter
> the contents (i.e. issue update/delete commands), but looking is just
fine?
>
> Much thanx for any assistance/enlightenment you can offer,
> Chuck
>
> P.S. Please cc me at my mail account.
>
Received on Fri Feb 21 2003 - 14:43:21 CST