database link in oracle 10g

Question

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.

possible duplicate of Correct way to give users access to additional schemas in Oracle — shamittomar
– shamittomar, Commented Sep 10, 2010 at 6: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
– Jeffrey Kemp, Commented Sep 14, 2010 at 5:56

Community · Accepted Answer · 2017-05-23 10:30:25Z

1

I do believe your question have been answered already:

Correct way to give users access to additional schemas in Oracle

Does that help?

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Sep 10, 2010 at 6:45

Robin

5754 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2010-09-10 06:46:27Z

0

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

answered Sep 10, 2010 at 6:46

Rahul

1,88618 silver badges32 bronze badges

Collectives™ on Stack Overflow

database link in oracle 10g

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related