Re: DBLINKs in critical production system

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

--
http://www.freelists.org/webpage/oracle-l