Coba login ke database nya sebagai sysdba, baru dah bermain2 dengan grant. kalo mo main2 denga drop user juga boleh tuch, he..he..he.., kalo saya sich, nyiasatin tuch waktu bikin schema userY grantnya sysdba buat dia
2008/10/20 murdi santoso <[EMAIL PROTECTED]> > pake dblink dunk.... > nanti dijamin bisa deh.... > > <font color="#7f003f"><strong><img src=" > http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/14.gif > "></strong></font> > <font color="#7f003f"><strong>--Murdi Santoso--</strong> > </font> > > ________________________________ > From: trankkinaz <[EMAIL PROTECTED] <trankkinaz%40gmail.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Monday, October 20, 2008 10:29:48 AM > Subject: [indo-oracle] Grant select database lain.... > > > Hello expert!, > > need help nieh... > ada satu dabase namanya DBX dengan user UserX punya tabel namanya TabelX > ada Database lain namanya DBY dengan userY. > > gimana caranya agar userY bisa akses Tabel X ? > sudah dicoba : > 1. login denga UserX trus > grant select on TabelX to UserY --> Gagal > 2.login denga UserX trus > grant select on TabelX to DBY.UserY --> Gagal > > Mohon pencerahannya ! > Tks > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
