Re: why can I logon in restricted mode?

Ok. Thanx to Mr. Bakker, I figured out what was wrong.

I had created the "normal" user I was testing with months ago and forgot that I granted roles to the user. One of the roles granted was DBA, which, of course, has RESTRICTED SESSION privilege.

Boy, do I feel like an IDIOT!!!!!!!

Thanx to everyone for all your time, patience, and trouble, Chuck

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:e37d5v4j250ckitv6r2n21v7mt3hhafqa8_at_4ax.com...
> On Fri, 21 Feb 2003 16:14:21 -0500, "Chuck Lucas"
> <chuck.lucas_at_mspb.gov> wrote:
>
> >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
>
> Try the following
> startup restrict
>
> connect using the affected user name and password
> now issue
> select * from session_privs;
>
> Does it show 'restricted session' privilege? If it does, revoke it
> using the user SYS
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Fri Feb 21 2003 - 16:20:20 CST