Coba login dengan menggunakan "OS authentication" (alias tanpa password)
$ sqlplus /nolog SQL> connect / as sysdba SQL> show user USER is "SYS" Nah dari sini bisa deh ganti password SYS (kalau mau). SQL> ALTER USER SYS IDENTIFIED BY oracle; What is "OS authentication" ? - Yaitu mekanisme login yg menggunakan authentikasi di level OS. Jadi kalau sudah bisa login di level OS (misal : user "oracle" di UNIX atau user Administrator di Windows) utk masuk ke database tidak perlu password lagi. Cara settingnya? - Kalau di UNIX/Linux, (biasanya) masukkan OS user ke dalam dalam group "dba" - Kalau di Windows, masukkan OS user ke dalam group ORA_DBA. Selain itu settingan di sqlnet.ora juga berperan. Jadi nggak perlu report2 tahu password SYS CMIIW Bowo --- In [email protected], Heriyanto KO <[EMAIL PROTECTED]> wrote: > > login sebagai user yang memilki privellege yang lebih tinggi > mungkin bisa system > > dendi <[EMAIL PROTECTED]> wrote: > connect system/manager > dan ganti password untuk SYS > > > ----- Original Message ----- > From: "Toni Iskandar" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: 06 October 2005 14:40 > Subject: [indo-oracle] ganti password SYS > > > > > > Rekan2 Milis, > > Saya mau tanya gimana caranya mengganti password user SYS > > sedangkan saya engga tau password yg lamanya (dulu yg install orang lain). > > Mohon bantuan rekan2, urgent nih... > > > > > > [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.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > ============================================ > > > > This E-mail Was Scanned by Messaging Security Suite > > > > ============= Provided by IT Hardware ============= > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > SPONSORED LINKS > Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "indo-oracle" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
