Solved...

hasil ngulik manual ^_^ (RTFM!)
Dengan dblink!
di userY:
create database link X
connect to UserX  
identified by PassX
using 'Sid_X';

----
tks!


trankkinaz wrote:
>
> 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
>
> 
>
> __________ Information from ESET NOD32 Antivirus, version of virus 
> signature database 3536 (20081019) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com

Kirim email ke