RE: connect / as sysdba on 9i

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 05 Feb 2004 15:01:11 +0000
Message-Id: <s0225acd.013@bristol21.bristol.ac>

Remote_login_passwordfile applies to 'remote' connections. Note that sqlplu=
s /@dbname as sysdba is a 'remote' connection even if run from the console.=
 For local connections it works the same way IIRC, but the group is ORA_DBA=

 or ORA_SID_DBA.=20

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20

-----Original Message-----
From: rafiq9857_at_yahoo.com=20
Sent: 05 February 2004 14:44
To: oracle-l_at_freelists.org; rafiq9857_at_yahoo.com Subject: Re: connect / as sysdba on 9i

Kirti,

What about Windows 2000 when same behaviour while logging as sys(not system= )as

and user is a part of dba group. I think it depends on setting of=20 remote_login_passwordfile=3DEXCLUSIVE( if setting is NONE no problem).

Regards
Rafiq

• Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com> wrote:
  > Your UNIX id is not in the 'dba' group.=20
  >=20
  > - Kirti=20
  >=20 >=20 >=20
  > --- "Daiminger, Helmut" <HELMUT.DAIMINGER_at_WWK.DE> wrote:
  > > Hi!
  > >=20
  > > What parameters need to be set to allow
  > >=20
  > > connect / as sysdba on 9i?
  > >=20
  > > On my db this is disabled. Only "connect sys/pwd_at_database as sysdba"
  works.
  > >=20
  > > Any ideas?
  > >=20
  > > This is 9.2 on HP-UX.
  > >=20
  > > Thanks,
  > > Helmut
  > >=20
  > >=20
  > > ----------------------------------------------------------------
  > > 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
  > > -----------------------------------------------------------------
  >=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_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! 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_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
-----------------------------------------------------------------




**********************************************************************
This email contains information intended for
the addressee only.  It may be confidential
and may be the subject of legal and/or
professional privilege.  Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************

----------------------------------------------------------------
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 - 09:01:11 CST