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]> 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]> 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]
---------------------------------
Get your email and more, right on the new Yahoo.com
[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/
