RE: connect / as sysdba on 9i

  • From: Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 5 Feb 2004 07:25:20 -0800 (PST)

Sorry, I could not follow what's said here, but it is FALSE !! ;)   

That parameter only affects 'select any table' system privilege, which, btw, 
defaults to FALSE in 
to prevent users with 'select any table' from accessing SYS owned tables. 
Setting it to TRUE is
required if such access is to be allowed. 

It does not affect database connectivity.  


- Kirti 


--- A.Bahar@xxxxxxxxxxxxxxxxxxxxxx wrote:
> Hi
> 
>  Sie sollen setzen   o7_dictionary_accessibilty =3D true
> 
> Arslan.
> 
> -----Original Message-----
> From: Daiminger, Helmut [mailto:HELMUT.DAIMINGER@xxxxxx]
> Sent: Thursday, February 05, 2004 11:35 AM
> To: 'oracle-l@xxxxxxxxxxxxx'
> Subject: connect / as sysdba on 9i
> 
> 
> Hi!
> 
> What parameters need to be set to allow
> 
> connect / as sysdba on 9i?
> 
> On my db this is disabled. Only "connect sys/pwd@database as sysdba" =
> works.
> 
> Any ideas?
> 
> This is 9.2 on HP-UX.
> 
> Thanks,
> Helmut
> 
> 
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------


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

Other related posts: