开发者

database link in oracle 10g

开发者 https://www.devze.com 2023-01-16 03:05 出处:网络
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

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" ?

0

精彩评论

暂无评论...
验证码 换一张
取 消