Re: why can I logon in restricted mode?

To all that answered, MUCH thanx!

I tried all the different suggestions, even going so far as shutting the database down again and reopening in restricted mode. I can still log in with the "normal" user--which, by the way, I checked the privileges table and the "normal" user does NOT have RESTRICTED SESSION privilege.

Perhaps I should look some more through the Oracle site and see if there's a bug/patch I overlooked.

Again, thanx for all your time and trouble, Chuck

"Chuck" <chuckh_at_softhome.net> wrote in message news:Xns93299E3517D59chuckhsofthomenet_at_130.133.1.4...
> "Chuck Lucas" <chuck.lucas_at_mspb.gov> wrote in
> 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.
> >
> >
>
> "ALTER DABABASE OPEN" opens it in unrestricted mode, undoing whatever you
> did in the previous command. You want to say "ALTER DABABASE OPEN
> RESTRICT".
Received on Fri Feb 21 2003 - 15:14:21 CST