Message-Id: <10541.110518@fatcity.com> From: Uma Sankara_Sivadanam Date: Tue, 27 Jun 2000 16:48:58 +0530 Subject: RE: Granting sysdba to a user This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFE029.7DEE5050 Content-Type: text/plain 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@hotmail.com] > Reply To: ORACLE-L@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@db.com > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >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@fatcity.com > >cc: > > > >Hi all, > > I'm new to DBA related jobs. My boss wants to grant sysdba to a > >user . > > > >regards, > >Raman > > ------_=_NextPart_001_01BFE029.7DEE5050 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Granting sysdba to a user

I believe you need = not shutdown the machine.But only the database should be = bounced.Correct me if i am wrong.