RE: connect / as sysdba on 9i
- From: Mohammad Rafiq <rafiq9857@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 5 Feb 2004 07:38:24 -0800 (PST)
Niall,
Thanks for your response. What about when I connect to server through
PCAnywhere , my login id is a part of dba_group and when I connect locally as
sys is requires password as mentioned by Hemant.
Regards
Rafiq
--- Niall Litchfield <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
> 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@xxxxxxxxx=20
> Sent: 05 February 2004 14:44
> To: oracle-l@xxxxxxxxxxxxx; rafiq9857@xxxxxxxxx
> 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@xxxxxxxxx> wrote:
> > Your UNIX id is not in the 'dba' group.=20
> >=20
> > - Kirti=20
> >=20
> >=20
> >=20
> > --- "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> 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@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@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
> > > -----------------------------------------------------------------
> >=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
> > -----------------------------------------------------------------
>
>
> __________________________________
> 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
> -----------------------------------------------------------------
>
>
>
>
> **********************************************************************
> 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@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:
