Re: sysdba -- O7_DICTIONARY_ACCESSIBILITY

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 13 Jul 2004 22:22:30 +0800
Message-Id: <6.1.0.6.0.20040713221511.024adf30@pop.singnet.com.sg>

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
-----------------------------------------------------------------

Received on Tue Jul 13 2004 - 09:27:12 CDT