I am sorry it should be exclusive otherwise u cant grant sysdba to the user
>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: Thu, 09 Nov 2000 05:30:42 -0800
>
>I think you meant 'exclusive' instead of 'shared'. RBG
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Wednesday, November 08, 2000 3:46 PM
>
>
> > 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
> > 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.
Received on Thu Nov 09 2000 - 09:14:44 CST
