Lisa,
I agree with Stephane. I would create the account in the Production
database, and grant select access on the views to that account. It is much
easier to manage, not having to remember that the production database is
being accessed from "another" database via db links. Also, it solves all
Lisa Clary wrote:
>
> We have approximately 40 or so people external to this office and to our
> operation that require access to confidential information (with that
> population is increasing). The connections to Oracle are made through
> DSN/ODBC using various applications (access, excel,etc) a