Re: how to generate a randomized "seqno" column

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Fri, 20 Oct 2006 13:11:21 GMT
Message-ID: <J7FrB4.Fzs@igsrsparc2.er.usgs.gov>

Cris wrote:
> DA Morgan wrote:
>

>> In 10g use DBMS_CRYPTO.RANDOMINTEGER or DBMS_CRYPTO.RANDOMNUMBER.

>
> A couple of questions: I noticed that in 10.0.1.5 SE (Linux) the package
> "DBMS_CRYPTO" is owned by SYS (of course) but it seems execution it's
> not granted to anyone (but a public synonym DBMS_CRYPTO exists).
>
> Is there a reason for that? Is it safe to grant execute on this package
> to a user manually?
>

If the user needs access to this package, then grant EXECUTE on the package to the user.

Oracle is tightening up some grants of some packages, which is a good thing, IMO.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Fri Oct 20 2006 - 08:11:21 CDT