Re: Need an explanation for

From: <Winnie_Liu_at_infonet.com>
Date: Tue, 17 Oct 2000 15:43:48 -0700
Message-Id: <10652.119556@fatcity.com>

Scott was granted with SYSDBA role. And it had an entry in the password file. That is why Scott can startup the database when the data dictionary is not up

Winnie

"mike ding" <mding1997_at_mail.net>@fatcity.com on 10/17/2000 08:51:35 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Re: Need an explanation for

I tested and it works as you said. it seems you can use whatever valid username/pwd with 'as sysdba' to log into as 'sys' as long as you are logging to the server as 'oracle' or member of dba group, even the user is not belonging to v$pwfile_users. If you log into server as 'scott', and then
you will see it doesn't work.

mike

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 17, 2000 9:05 AM

> Hi DBAs,
>
> I have a funny query in my mind & I a convincing explanation from You.
> I granted DBA role to scott user for test purpose.
> But scott is able to connect as SUSDBA thru svrmgrl & able to start ,
> shut the database.
>
> My doubt is , during startup when the datanase is not up how DBA role
> is effective to scott user as Oracle has not mounted the data dictionery
> to refer the roles granted to scott user.
>
> Any explanations please ?
>
> I have give the sequence of actions below as it was.
>
> Thanks
>
> S Jayakumar
>

>
> Connected.
> SVRMGR> create role abc ;
> Statement processed.
> SVRMGR> grant dba to abc ;
> Statement processed.
> SVRMGR> grant abc to scott;
> Statement processed.
> SVRMGR> shutdown
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SVRMGR>
> SVRMGR>
> SVRMGR> connect scott/tiger as sysdba;
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 7650832 bytes
> Fixed Size 48656 bytes
> Variable Size 6701056 bytes
> Database Buffers 819200 bytes
> Redo Buffers 81920 bytes
> Database mounted.
> Database opened.
> SVRMGR> shutdown
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
>

>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: S Jayakumar
> INET: jaykumar_at_mahindrabt.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mike ding
  INET: mding1997_at_mail.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Tue Oct 17 2000 - 17:43:48 CDT