Niall Litchfield wrote:
>
> Mike wrote:
> > The database link is public and without username and password. It is
> > for sox compliance.
> >
> That seems an interesting approach to SOX compliance. Allow anyone who
> gains access to db A automatic access to db B? Is that really what is
> desired?
>
> --
>
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
Doesn't a dblink without uid/pass only allows access if you have an
account on both databases? So in the OP's case, just having an account
on database A doesn't mean that you'll get access to database B (unless
you have the same account/password defined on database B)
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"Semper in excremento, sole profundum qui variat."
------------------------------------------------------------
Received on Thu Jan 12 2006 - 07:25:48 CST
