How do i grant access on objects in one db to a user in a different database over a db link. WHat is the command.
I have 2 databases (ora1 & ora2) both 8i . i have created a database link from user1 in ora1 to user2 in ora2 .
Now i want to grant execute on certain object types created in user1 of ora1 to user2 of ora2 so that it can be used in stored procedures in user2 schema of ora2.
Is it possible to give such a grant over a db link or will i have to recreate the whole type in user2 schema of ora2 db.
If its possible to give such a grant over db link please do respond