Thanks, Jacques. I stand corrected. We leave O7_DICTIONARY_ACCESSIBILITY to FALSE in all 9i databases, and I did not test the connectivity with it set to TRUE prior to my post. Now, I will remember that !! Cheers! - Kirti --- Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote: > The O7_DICTIONARY_ACCESSIBILITY parameter DOES affect database = > connectivity. > If O7_DICTIONARY_ACCESSIBILITY =3D TRUE, > then I can say > connect sys/password without the "as sysdba" > If O7_DICTIONARY_ACCESSIBILITY =3D FALSE, then I CANNOT > connect sys/password without the "as sysdba" > > See example on SunOS 9.2 > > SQL> connect system > Enter password:=20 > Connected. > SQL> select a.instance_name, b.name as database_name > 2 from v$instance a, v$database b ; > INSTANCE_NAME DATABASE_ > ---------------- --------- > sdu2920a SDU2920A > SQL> show parameter O7_DICTIONARY_ACCESSIBILITY > NAME TYPE VALUE > ------------------------------------ ----------- = > ------------------------------ > O7_DICTIONARY_ACCESSIBILITY boolean FALSE > SQL> connect sys > Enter password:=20 > ERROR: > ORA-28009: connection to sys should be as sysdba or sysoper > Warning: You are no longer connected to ORACLE. > SQL> exit > > irvspcu01 # export ORACLE_SID=3Dsdu2920b > irvspcu01 # sqlplus /nolog > SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 5 10:40:13 2004 > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > SQL> connect system > Enter password:=20 > Connected. > SQL> select a.instance_name, b.name as database_name > 2 from v$instance a, v$database b ; > INSTANCE_NAME DATABASE_ > ---------------- --------- > sdu2920b SDU2920B > SQL> show parameter O7_DICTIONARY_ACCESSIBILITY > NAME TYPE VALUE > ------------------------------------ ----------- = > ------------------------------ > O7_DICTIONARY_ACCESSIBILITY boolean TRUE > SQL> connect sys > Enter password:=20 > Connected. > SQL>=20 > > > -----Original Message----- > > Kirtikumar Deshpande > >=20 > > Sorry, I could not follow what's said here, but it is FALSE !! ;) =20 > >=20 > > That parameter only affects 'select any table' system=20 > > privilege, which, btw, defaults to FALSE in=20 > > to prevent users with 'select any table' from accessing SYS=20 > > owned tables. Setting it to TRUE is > > required if such access is to be allowed.=20 > >=20 > > It does not affect database connectivity. =20 > >=20 > >=20 __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------