RE: Granting sysdba to a user

Hello...
I am very sorry I said that the machine had to be shut down It was a typing mistake

>From: Winnie_Liu_at_infonet.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Granting sysdba to a user
>Date: Tue, 27 Jun 2000 10:08:05 -0800
>
>
>Of course just to change a parameter of the init.ora file does not require
>you to restart the machine, just the database.
>
>Winnie
>
>
>
>
>
>Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com> on 06/27/2000
>05:26:06 AM
>
>Please respond to ORACLE-L_at_fatcity.com
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
>I believe you need not shutdown the machine.But only the database should be
>bounced.Correct me if i am wrong.
>
> > ----------
> > From: ARUN K C[SMTP:arun_k_c_at_hotmail.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Tuesday, June 27, 2000 4:41 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Granting sysdba to a user
> >
> > first you will have to change remote_login_passwordfile = EXCLUSIVE in
>the
> >
> > init paramater .
> > for this to get activated you will have to shutdown the m/c and restart
> > it.
> > once this is done you can give sysdba rights to any user,but be careful
>in
> >
> > giving these rights this is a very critical role.
> >
> >
> > >From: raman.yagna_at_db.com
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Granting sysdba to a user
> > >Date: Mon, 26 Jun 2000 23:34:03 -0800
> > >
> > >Hi all,
> > > Sorry for the previous mail. Clicked the wrong icon (send) .
> > >
> > >My environment is
> > >ORacle 8.1.6 .
> > >Aix 4.3.2
> > > What should i do to grant SYSBDA to user created .
> > >Now its failing with the following error ,
> > >
> > >ORA-01994: GRANT failed: cannot add users to public password file
> > >
> > >I connect as ,
> > >
> > >sqlplus /nologs
> > >connect / as sysdba
> > >
> > >regards,
> > >Raman
> > >
> > >
> > >---------------------- Forwarded by Raman Yagna on 27/06/2000 14:24
> > >---------------------------
> > >
> > >
> > >To: ORACLE-L_at_fatcity.com
> > >cc:
> > >
> > >Hi all,
> > > I'm new to DBA related jobs. My boss wants to grant sysdba to a
> > >user .
> > >
> > >regards,
> > >Raman
> >
> >
>
><< att1.htm >>