Re: Need an explanation for

From: <Chaim.Katz_at_Completions.Bombardier.com>
Date: Tue, 17 Oct 2000 11:03:17 -0400
Message-Id: <10652.119471@fatcity.com>

S Jayakumar <jaykumar_at_mahindrabt.com> on 10/17/2000 09:05:47 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

Subject: Need an explanation for

I don't think it has anything to do with the DBA role or the Scott schema
(unless you granted sysdba to scott)

Try: connect scott/viger as sysdba or connect / as sysdba

If these connections work, the explanation is that your OS user account is a member of the ORA_DBA group. In that case, Oracle is not looking at the username password that you supply.

Chaim

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 - 10:03:17 CDT