Hi before creating a database link .
grant permission has to be given to the dblink user and then create a database link
grant select on table_neme to remote_link_user ;
create database link link_name connect to remote_link_user using database_alias ;
Hope it is clear .




Reply With Quote