CODEWITHSUNDEEP
sqloracle10g
Jagan
Jagan

Reputation: 4897

database link in oracle 10g

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 XE.

Upvotes: 0

Views: 565

Answers (2)

Rahul
Rahul

Reputation: 1876

I am not at all familiar with Oracle but does "jagan" have read permissions/ownership over "XE" ?

Upvotes: 0

Robin
Robin

Reputation: 575

I do believe your question have been answered already:

Correct way to give users access to additional schemas in Oracle

Does that help?

Upvotes: 1

Related Questions