Couldn't have said it better myself. That's what I meant, of course,
but shame on me for not including the details. I was so excited about
catching Jared in an error that I rushed my post! ;-)
- Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> SYS connecting without SYSDBA/SYSOPER is possible in 9i only if
> O7_DICTIONARY_ACCESSIBILITY is set to TRUE.
> This parameter defaults to TRUE in 8i but FALSE in 9i.
>
> If you want to connect as SYS without the "AS SYSDBA" [or SYSOPER],
> you must
> have had O7_DICTIONARY_ACCESSIBILITY set to TRUE.
>
> At 02:31 AM Tuesday, you wrote:
> > > Not true. It IS true that the only way to connect as SYS is AS
> SYSDBA,
> > > and you can do that from most any client tool (SQL*Plus, OEM,
> even
> > > imp).
> >The statement that the only way to connect as sys is "as sysdba" is
> false.
> >The statement that you may also connect via OEM, imp, etc is true.
> >Jared
>
>
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> http://web.singnet.com.sg/~hkchital
> "A man's reputation is what other people think of him; his character
> is
> what he really is."
> -- Miner, Jack
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 13 2004 - 11:48:01 CDT
