I have two users System and jagan in oracle10g . I could display contents of table TAB (select *from tab) when i login as system.But i want same result when i login as jagan also.. database name is XE. Can somebody give me syntax to create database link from jagan to X开发者_运维百科E.
I do believe your question have been answered already:
Correct way to give users access to additional schemas in Oracle
Does that help?
I am not at all familiar with Oracle but does "jagan" have read permissions/ownership over "XE" ?
精彩评论