Re: DBLINKs in critical production system
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: Ajay_Thotangare@xxxxxx
- Date: Mon, 30 Apr 2007 12:57:42 -0500
Anjay,
Often a dblink points to a schema owner. This gives the person on the other
end of the dblink unfettered access to the entire schema, not just the table
for which you created the dblink. One way this can be made more secure is to
create a separate username on each database. Create the dblink between these
two usernames. Grant only the needed access to these usernames. Create
synonyms as needed to make the access syntatically more convenient.
Dennis Williams
Other related posts:
