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