| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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).
Share information about yourself, create your own public profile at Received on Wed Nov 08 2000 - 14:36:19 CST
 |
 |