911299 wrote:The database in which the link is defined is connecting to 'clone' with credentials for user 'apps' as defined in 'clone'. This is exactly as if you were to 'sqlplus app/123456@clone'. The permissions available are those that are granted to the clone account 'app'.
Thanks for quick reply .
I have created db link , how should i grant select permission on apps view to another database schema.
SQL> create database link erp02
2 connect to apps identified by 123456
3 using 'clone';
Database link created.