Re: SYSDBA

From: <Winnie_Liu_at_infonet.com>
Date: Wed, 8 Nov 2000 13:29:50 -0800
Message-Id: <10674.121500@fatcity.com>

Arun is right. You will need to set the remote_login_password_file=shared in order to use the sysdba/sysoper to lononto the database. But you should definitely need to create a password file in your dbs directory to protect this logon. The person with SYSDBA/SYSOPER is a super user, not just a DBA, but it can even delete file that is owned by oracle through OS.

Winnie

"ARUN K C" <arun_k_c_at_hotmail.com>@fatcity.com on 11/08/2000 12:46:35 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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 Wed Nov 08 2000 - 15:29:50 CST