why can I logon in restricted mode?

From: Chuck Lucas <chuck.lucas_at_mspb.gov>
Date: Fri, 21 Feb 2003 14:24:31 -0500
Message-ID: <b35u8i$89g$1@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 - 13:24:31 CST