RE: connect / as sysdba on 9i

From: Husak, Orysia - Perot <OHusak_at_chw.edu>
Date: Thu, 5 Feb 2004 06:52:41 -0700
Message-ID: <4A778810F700DA4A984A7753319D7EB40169EB4F@srdh-msg-01.chw.edu>

In init.ora set up os_authent_prefix
create user identified externally
grant sysdba to that user

should work then

Orysia

-----Original Message-----

From: Freeman, Donald [mailto:dofreeman_at_state.pa.us] Sent: Thursday, February 05, 2004 6:46 AM To: oracle-l_at_freelists.org
Subject: RE: connect / as sysdba on 9i

I'm not positive how this works on HP but check your sqlnet.ora file for = sqlnet_authentication=3D(NTS).

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daiminger, Helmut Sent: Thursday, February 05, 2004 5:35 AM To: 'oracle-l_at_freelists.org'
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_at_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_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


-----------------------------------------------------------------

----------------------------------------------------------------

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

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 Thu Feb 05 2004 - 07:52:41 CST