Message-Id: <10541.110559@fatcity.com> From: Winnie_Liu@infonet.com Date: Tue, 27 Jun 2000 09:57:28 -0700 Subject: 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 on 06/27/2000 05:26:06 AM Please respond to ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L 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@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 > > --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