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 -----
From: S Jayakumar <jaykumar_at_mahindrabt.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, October 17, 2000 9:05 AM
Subject: Need an explanation for
> 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
Received on Tue Oct 17 2000 - 09:48:15 CDT
