This content has been marked as final. Show 4 replies
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;