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