0

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.

Jagan
  • 4,649
  • 19
  • 60
  • 70
  • possible duplicate of [Correct way to give users access to additional schemas in Oracle](http://stackoverflow.com/questions/198952/correct-way-to-give-users-access-to-additional-schemas-in-oracle) – shamittomar Sep 10 '10 at 06:47
  • sounds like you're conflating 'user' (e.g. `jagan`) with 'database' (e.g. `XE`) - a database link is only useful when you have 2 databases. – Jeffrey Kemp Sep 14 '10 at 05:56

2 Answers2

1

I do believe your question have been answered already:

Correct way to give users access to additional schemas in Oracle

Does that help?

Community
  • 1
  • 1
Robin
  • 555
  • 4
  • 14
0

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

Rahul
  • 1,866
  • 17
  • 32