Re: Compare CLOBs over dblink

From: Andy Klock <andy_at_oracledepot.com>
Date: Wed, 3 Nov 2010 14:58:14 -0400
Message-ID: <AANLkTi=nVJ_Q+8zM=up+tzH3afaRVKQTWH-NhKKbbPZW_at_mail.gmail.com>

You definitely could, but the OP voiced a concern that granting this package could potentially be a security risk. Always a valid concern and one of the reasons why PUBLIC doesn't get granted to it like dbms_obfuscation_toolkit was. (Saves us the step of having to revoke it).

Now is it overkill to tuck it in another procedure to grant? Possibly, but not my call to make. And as of 10g, this package is included in standard edition. Though using it with ASO, TDE, etc would require more of a license than SE offers.

On Wed, Nov 3, 2010 at 2:29 PM, Mark Weaver <mark-clist_at_npsl.co.uk> wrote:

> On 01/11/2010 15:59, Andy Klock wrote:
>
>> I don't have experience comparing "large" lobs over a db link, but I'd
>> be inclined to use your dbms_crypto.hash method. Create a new function
>> that just calls dbms_crypto.hash and grant execute on that to your
>> developer.
>>
>> Why wouldn't you just grant them execute on dbms_crypto?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Nov 03 2010 - 13:58:14 CDT