This content has been marked as final. Show 4 replies
sounds like you need to grant select to the schema that your application is parsed by to that other schema
can you please give me a sample code that I may share with my admin as a reference
You need to grant the required permission (if there is no restriction then you can use GRANT ALL), You can give the permission to particular user on the schema.
Refer these links,
conn / as sysdba grant select on userA.table_name to userB; connect userB/passwordB select userA.table1.column1, table2.column2 from userA.table1, table2;
Thanks again for your assistance