I've two oracle databases with each one schema and user.
I had created dblink between these databases.
How do I give grant option to other database schema
user from the previous one for some objects.
When you create a db link, you always should use a user to connect to the remote database, if this user has the grant with grant option through the objects, then the use could give permissions on this objects to other users.
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 .