Re: a bit tricky question

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 11 Jan 2006 21:04:40 +0100
Message-ID: <dq3nng$csh$1@news3.zwoll1.ov.home.nl>

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?
>

I think what is meant is an Oracle recommended approach in which the db link is created as public link, but the username and password are part of a private db link definition.

As system:
create public database link blah using 'db920.csdb02.cs.nl';

As scott:
create database link blah connect to system identified by manager;

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Wed Jan 11 2006 - 14:04:40 CST