biar lebih jelas bisa di baca di sini http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#sthref134
On 8/29/06, Didit Aditia <[EMAIL PROTECTED]> wrote: > > Kayaknya utk local pake OS authentication, jadi begitu login user oracle > di OS dan connect ke db langsung bisa as sysdba...mungkin gak? > > > Yoel <[EMAIL PROTECTED] <yoel.ade%40gmail.com>> wrote: 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]<didit_aditia%40yahoo.com>> > 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> <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> > <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> > <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> > > <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><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><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><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] > > > > > > > --------------------------------- > Stay in the know. Pulse on the new Yahoo.com. Check it out. > > > [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/
