Jadi user Oracle yg mau dibuat supaya gak bisa 'sqlplus as sysdba' dari server database? Kalau gitu, maka ignore saja email saya sebelumnya. Saya kira yg mau di-disable adalah user lain.
Coba ubah sqlnet.ora di $ORACLE_HOME/network/admin. Tambahkan entry berikut: SQLNET.AUTHENTICATION_SERVICES = (NONE) Parameter ini memastikan setiap koneksi utk memakai password, walaupun konek dari lokal server. Pastikan parameter REMOTE_LOGIN_PASSWORDFILE sudah EXCLUSIVE. regards, tomi --- Didit Aditia <[EMAIL PROTECTED]> wrote: > Maaf mas Tomi caranya gimana? udah coba, > > "cannot remove user 'oracle' from their primary > group" > > Seharusnya user yg install beda dgn user yg access > ya? > > maaf orang baru nih..OS RH 4. > > Tomi Wijanto <[EMAIL PROTECTED]> wrote: > Udah cek OS Group dari user > bersangkutan? > Apakah group user tsb termasuk DBA (unix) atau > ORA_DBA > (windows). > Kalau iya, remove aja. > > regards, > tomi > > --- 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? > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > > > > > --------------------------------- > How low will we go? Check out Yahoo! Messengers low > PC-to-Phone call rates. > > [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 > > > [EMAIL PROTECTED] > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------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/
