Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sys as sysdba on root user

Re: sys as sysdba on root user

From: bitmus <d.bitmus_at_yahoo.com>
Date: Thu, 28 Jun 2007 18:03:02 -0700
Message-ID: <1183078982.238043.230410@q75g2000hsh.googlegroups.com>


thanks for reply.

Are you mean it is not possible to connect using "as sysdba" on root user?
i have very need to use root.
plz help me

Very thanks

Mark D Powell wrote:
> On Jun 28, 9:06 am, sybrandb <sybra..._at_gmail.com> wrote:
> > On Jun 28, 12:33 pm, bitmus <d.bit..._at_yahoo.com> wrote:
> >
> >
> >
> >
> >
> > > Hi.
> >
> > > i've faced a problem that connecting sys as sysdba is always giving
> > > ORA-01031: insufficient privileges.
> > > the problem is only occured when using as sysdba on root user. if i
> > > connect using system/blabla, there is no error.
> >
> > > also connecting sys as sysdba is ok for other system user such as
> > > oracle.
> >
> > > i have added root user to dba group. that is not helped me.
> > > and i compared root user to other system user, and i did not found any
> > > other differences.
> > > Help me.
> >
> > > Thanks.
> >
> > Why do you want to misuse root to connect as a sysdba user to the
> > database? As you are root, su - oracle -c <command> allows you to
> > execute *anything* as user oracle.
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA- Hide quoted text -
> >
> > - Show quoted text -
>
> Sybrand is most definitely correct. You should never use the root
> account to directly access Oracle but should either su - oracle to run
> DBA type tasks and just connect via a valid Oracle username for
> running scripts.
>
> -- Mark D Powell --
Received on Thu Jun 28 2007 - 20:03:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US