RE: Granting sysdba to a user

--0__=ginJ49s6AAGxEbWQgkVDTIsIxKUwb6F2cYx8XjgT1h1TxFcNhcRBYUWC Content-type: text/plain; charset=us-ascii Content-Disposition: inline

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)

Subject: 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.

> ----------
> 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
>
>

--0__=ginJ49s6AAGxEbWQgkVDTIsIxKUwb6F2cYx8XjgT1h1TxFcNhcRBYUWC Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PXVzLWFzY2lpIj4NCjxNRVRBIE5BTUU9IkdlbmVyYXRvciIgQ09OVEVOVD0i TVMgRXhjaGFuZ2UgU2VydmVyIHZlcnNpb24gNS41LjI2NTAuMTIiPg0KPFRJVExFPlJFOiBHcmFu dGluZyBzeXNkYmEgdG8gYSB1c2VyPC9USVRMRT4NCjwvSEVBRD4NCjxCT0RZPg0KDQo8UD48Rk9O VCBDT0xPUj0iIzAwMDBGRiIgU0laRT0yIEZBQ0U9IkFyaWFsIj5JIGJlbGlldmUgeW91IG5lZWQg bm90IHNodXRkb3duIHRoZSBtYWNoaW5lLkJ1dCBvbmx5IHRoZSBkYXRhYmFzZSBzaG91bGQgYmUg Ym91bmNlZC5Db3JyZWN0IG1lIGlmIGkgYW0gd3JvbmcuPC9GT05UPg0KPC9QPg0KPFVMPg0KPFA+ PEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPi0tLS0tLS0tLS08L0ZPTlQ+DQo8QlI+ PEI+PEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPkZyb206PC9GT05UPjwvQj4gJm5i c3A7IDxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5BUlVOIEsgQ1tTTVRQOmFydW5f a19jQGhvdG1haWwuY29tXTwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2Fu cyBTZXJpZiI+UmVwbHkgVG86PC9GT05UPjwvQj4gJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7IDxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5PUkFDTEUtTEBmYXRjaXR5LmNv bTwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+U2VudDo8 L0ZPTlQ+PC9CPiAmbmJzcDsgPEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPlR1ZXNk YXksIEp1bmUgMjcsIDIwMDAgNDo0MSBBTTwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEgRkFD RT0iTVMgU2FucyBTZXJpZiI+VG86PC9GT05UPjwvQj4gJm5ic3A7Jm5ic3A7Jm5ic3A7IDxGT05U IFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5NdWx0aXBsZSByZWNpcGllbnRzIG9mIGxpc3Qg T1JBQ0xFLUw8L0ZPTlQ+DQo8QlI+PEI+PEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYi PlN1YmplY3Q6PC9GT05UPjwvQj4gJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 IDxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5SZTogR3JhbnRpbmcgc3lzZGJhIHRv IGEgdXNlcjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5maXJz dCB5b3Ugd2lsbCBoYXZlIHRvIGNoYW5nZSByZW1vdGVfbG9naW5fcGFzc3dvcmRmaWxlID0gRVhD TFVTSVZFIGluIHRoZSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5pbml0 IHBhcmFtYXRlciAuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Zm9yIHRo aXMgdG8gZ2V0IGFjdGl2YXRlZCB5b3Ugd2lsbCBoYXZlIHRvIHNodXRkb3duIHRoZSBtL2MgYW5k IHJlc3RhcnQgaXQuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+b25jZSB0 aGlzIGlzIGRvbmUgeW91IGNhbiBnaXZlIHN5c2RiYSByaWdodHMgdG8gYW55IHVzZXIsYnV0IGJl IGNhcmVmdWwgaW4gPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Z2l2aW5n IHRoZXNlIHJpZ2h0cyB0aGlzIGlzIGEgdmVyeSBjcml0aWNhbCByb2xlLjwvRk9OVD4NCjwvUD4N CjxCUj4NCg0KPFA+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7RnJvbTogcmFtYW4ueWFn bmFAZGIuY29tPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0O1JlcGx5 LVRvOiBPUkFDTEUtTEBmYXRjaXR5LmNvbTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0i QXJpYWwiPiZndDtUbzogTXVsdGlwbGUgcmVjaXBpZW50cyBvZiBsaXN0IE9SQUNMRS1MICZsdDtP UkFDTEUtTEBmYXRjaXR5LmNvbSZndDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFy aWFsIj4mZ3Q7U3ViamVjdDogR3JhbnRpbmcgc3lzZGJhIHRvIGEgdXNlcjwvRk9OVD4NCjxCUj48 Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDtEYXRlOiBNb24sIDI2IEp1biAyMDAwIDIzOjM0 OjAzIC0wODAwPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OzwvRk9O VD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDtIaSBhbGwsPC9GT05UPg0KPEJS PjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyBTb3JyeSBmb3IgdGhlIHByZXZpb3VzIG1haWwuIENsaWNrZWQgdGhlIHdyb25n IGljb24gKHNlbmQpIC48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7 PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0O015IGVudmlyb25tZW50 IGlzPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0O09SYWNsZSA4LjEu NiAuPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0O0FpeCA0LjMuMjwv Rk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDsmbmJzcDsmbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsgV2hhdCBzaG91bGQgaSBkbyB0byBncmFudCBTWVNCREEgdG8gdXNlciBj cmVhdGVkIC48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7Tm93IGl0 cyBmYWlsaW5nIHdpdGggdGhlIGZvbGxvd2luZyBlcnJvciAsPC9GT05UPg0KPEJSPjxGT05UIFNJ WkU9MiBGQUNFPSJBcmlhbCI+Jmd0OzwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJp YWwiPiZndDtPUkEtMDE5OTQ6IEdSQU5UIGZhaWxlZDogY2Fubm90IGFkZCB1c2VycyB0byBwdWJs aWMgcGFzc3dvcmQgZmlsZTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZn dDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7SSBjb25uZWN0IGFz ICw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7PC9GT05UPg0KPEJS PjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0O3NxbHBsdXMgL25vbG9nczwvRk9OVD4NCjxC Uj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDtjb25uZWN0Jm5ic3A7IC8gYXMgc3lzZGJh PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OzwvRk9OVD4NCjxCUj48 Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDtyZWdhcmRzLDwvRk9OVD4NCjxCUj48Rk9OVCBT SVpFPTIgRkFDRT0iQXJpYWwiPiZndDtSYW1hbjwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFD RT0iQXJpYWwiPiZndDs8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7 PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0Oy0tLS0tLS0tLS0tLS0t LS0tLS0tLS0gRm9yd2FyZGVkIGJ5IFJhbWFuIFlhZ25hIG9uIDI3LzA2LzIwMDAgMTQ6MjQgPC9G T05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0Oy0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDs8L0ZP TlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7PC9GT05UPg0KPEJSPjxGT05U IFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0O1RvOiZuYnNwOyZuYnNwOyBPUkFDTEUtTEBmYXRjaXR5 LmNvbTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDtjYzo8L0ZPTlQ+ DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7PC9GT05UPg0KPEJSPjxGT05UIFNJ WkU9MiBGQUNFPSJBcmlhbCI+Jmd0O0hpIGFsbCw8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZB Q0U9IkFyaWFsIj4mZ3Q7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 IEknbSBuZXcgdG8gREJBIHJlbGF0ZWQgam9icy4gTXkgYm9zcyB3YW50cyB0byBncmFudCBzeXNk YmEgdG8gYSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mZ3Q7dXNlciAu PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+Jmd0OzwvRk9OVD4NCjxCUj48 Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPiZndDtyZWdhcmRzLDwvRk9OVD4NCjxCUj48Rk9OVCBT Received on Tue Jun 27 2000 - 11:57:28 CDT