Re: Compare CLOBs over dblink

  • From: Andy Klock <andy@xxxxxxxxxxxxxxx>
  • To: mark-clist@xxxxxxxxxx
  • Date: Wed, 3 Nov 2010 14:58:14 -0400

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

Other related posts: