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]> wrote: coba execute REVOKE SYSDBA FROM SCOTT; terus coba connect lagi dengan scott On 8/28/06, Didit Aditia <[EMAIL PROTECTED]> 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>> 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>> 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>, > "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] -- -----------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/
