Maaf, kalimat Anda agak membingungkan Here's the rule: Kalo tidak di grant sysdba, selain user SYS tidak akan bisa login dengan menggunakan "as sysdba". kalo tidak mau ada remote login dengan "as sysdba" ganti parameter REMOTE_LOGIN_PASSWORDFILE='NONE'
On 8/29/06, Didit Aditia <[EMAIL PROTECTED]> wrote: > > Jika "grant sysdba to scott", scott bisa remote ke db production as > sysdba, tapi untuk di db productionnya semua "conn user as sysdba" akan jadi > sysdba tapi tidak bisa remote. > Gimana caranya jika ingin sys saja yg "as sysdba" di db production?... > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote: coba execute > REVOKE SYSDBA FROM SCOTT; > > > terus coba connect lagi dengan scott > > On 8/28/06, Didit Aditia <[EMAIL PROTECTED]<didit_aditia%40yahoo.com>> > wrote: > > > > semua user bisa mempunyai sysdba privileges jika connect menggunakan "as > > sysdba" > > SQL> conn scott/tiger as sysdba > > conected > > bagaimana caranya agar sys atau user yg d grant sysdba priv. saja yg > > memiliki sysdba privileges > > jimmy <[EMAIL PROTECTED] <jimmy_gaw%40yahoo.com><jimmy_gaw%40yahoo.com>> > > wrote: sekedar > > > masukan, > > > > bila ingin merubah password user sys, > > maka anda harus login dulu ke user sys sendiri atau > > login ke user lain yang sudah mendapat grant 'alter > > user'. > > setelah itu, anda baru bisa melakukan alter user sys > > identified by [new_passw]. > > Kalau password user sys nya sendiri tidak tahu, > > maka anda bisa connect sys / as sysdba. > > tapi ada beberapa langkah dahulu yg harus dilakukan > > supaya bisa connect ke user sys dengan cara seperti > > ini. > > > > Salam, > > > > --- sam_hidayat <[EMAIL PROTECTED] <sam_hidayat%40yahoo.com><sam_hidayat% > 40yahoo.com>> wrote: > > > > > Kalau anda telah bisa login sebgai system dgn > > > password yang sekarang, > > > di command prom tinggal ketiak aja password, ntar > > > ikuti aja langkah > > > langkahnya. > > > > > > --- In [email protected] > > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com>, > > > "didit aditia" > > > <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > Dear all, > > > > > > > > Jika ingin mengganti password sys di 10g gimana > > > ya? > > > > OS RH 4, > > > > mohon pencerahannya.... > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > > > > > > > > > > > --------------------------------- > > All-new Yahoo! Mail - Fire up a more powerful email and get things done > > faster. > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > --------------------------------- > Do you Yahoo!? > Get on board. You're invited to try the new Yahoo! Mail. > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
