Pasti ada orang yang grant ke semua user. By default hanya SYS yang punya hak sysdba
coba query V$PWFILE_USERS contoh di database saya : SQL> select * from v$pwfile_users; USERNAME SYSDB SYSOP ------------------------------ ----- ----- SYS TRUE TRUE YOEL TRUE FALSE user YOEL sudah di grant di sysdba, makanya ada di view tersebut. On 8/29/06, Didit Aditia <[EMAIL PROTECTED]> wrote: > > > Jadi di local/db production semua user yg connect dgn "as sysdba" akan > connect sbg sysdba (tdk perlu di grant as sysdba). > Bagaimana supaya hanya sys yg bisa conn as sysdba di local/db production. > Apa mungkin salah di instalasi awalnya? > > Maaf kalau kalimatnya tambah membingungkan, orang baru sih... > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote: 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]<didit_aditia%40yahoo.com>> > 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> <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> > <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><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><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><indo-oracle%40yahoogr > oups.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] > > > > > > > --------------------------------- > Get your email and more, right on the new Yahoo.com > > > [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/
