<div>
for 1) would you refer to the &quot;owner&quot; column if its &nbsp;a named user its a &quot;private&quot; link?
</div>


for 1) would you refer to the "owner" column if its  a named user its a "private" link?

<div>
<div class="content wysiwyg-content">
1) is there any easy way to determine whether a database link is &quot;public&quot; or private?<br />
<br />
2) where would you be able to tell, are there any clues in the dba_db_links table?<br />
<br />
3) what exactly is meant by &quot;private&quot; link, and how can you tell which users have access to use this &quot;private&quot; link? I am assuming &quot;public&quot; essentially means anyone with an account in the local database can access the remote database.<br />
<br />
4) also when a database link is active, how does a user query tables in that database once logged into their local database. do you have to add a database.table.colum type prefix to your sql?
</div>
</div>


1) is there any easy way to determine whether a database link is "public" or private?

2) where would you be able to tell, are there any clues in the dba_db_links table?

3) what exactly is meant by "private" link, and how can you tell which users have access to use this "private" link? I am assuming "public" essentially means anyone with an account in the local database can access the remote database.

4) also when a database link is active, how does a user query tables in that database once logged into their local database. do you have to add a database.table.colum type prefix to your sql?

public or private links

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.