Ad-hoc Tips (Database Links)

Posted on July 16, 2008. Filed under: DBA/Admin Tips |

Hope the Apps DBA community is doing great and is (as always) ever busy.This post is a small tip that might be of use.

Occasionally,in small companies (and most often in big companies),
there will be a necessity to create DB links between Apps database
and some legacy/standalone Oracle database.

We obviously don’t want them to
connect to our database as “apps” user via a DB link which is highly
insecure. So,in this case, it is a good idea to understand the list
of custom/apps objects that the legacy database need access to and
grant privileges ONLY to those objects. Here are the steps that we followed.

–> Got the list of objects (custom/standard) they need access to
–> Created a new database user for them
–> Grant SELECT on the objects to the new user
–> As the new user, create synonyms for the apps/custom objects.
–> Gave this new user (and tnsnames entry) to the other DBA team

This way, you can secure your objects against the misuse of DB links.

Other better ways? Please comment !!!

OraclePitStop team


Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: