I think you meant 'exclusive' instead of 'shared'. RBG
----- Original Message -----
From: "ARUN K C" <arun_k_c_at_hotmail.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, November 08, 2000 3:46 PM
Subject: Re: SYSDBA
> u just cant grant sysdba or sysoper to any user until and unless you have
> made the remote_login_password_file=shared.
> but please think before giving this permission cause he can do anything as
> he will be the super user of the database.
> and if you make this shared you will have to create a password file on
the
> dbs directory.
>
> >From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: SYSDBA
> >Date: Wed, 08 Nov 2000 11:01:28 -0800
> >
> >Try logging on as oracle before you connect to the database. Then connect
/
> >as sysdba.
> >
> > You won't have any pwfile users if you don't use a password file. Just
a
> >thot...
> >
> >Ruth
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> >Sent: Sunday, November 05, 2000 10:05 PM
> >
> >
> > > Lists,
> > > When i run select * from v$pwfile_users on my solaris machin returns
no
> > > rows(oracle 8.1.5 on solaris), I have tried to connect as sysdba but
> > > couldn't.
> > > How can i grant sysdba to sys, any idea appreciate.
> > > also i have run GRANT SYSDBA to SYS with admin option, but no
> > > way(insufficent prevelege)
> > > I can connect as sys/password but not sys/password as sysdba????
> > > Thanks
> > >
> > > Hamid Alavi
> > > DDI 3610148
> > > FAX 3610102
> > > 111 Franklin RD Freemans Bay Auckland
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Hamid Alavi
> > > INET: HamidA_at_aimdirect.co.nz
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ARUN K C
> INET: arun_k_c_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Nov 09 2000 - 07:26:19 CST
