Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to generate a randomized "seqno" column

Re: how to generate a randomized "seqno" column

From: Cris <cris119_at_operamail.com>
Date: Fri, 20 Oct 2006 14:24:15 +0200
Message-ID: <4538bff7$0$12408$5fc30a8@news.tiscali.it> 





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?


-- 
spamto:cris119_at_operamail.com

blind faith in your leaders or
in anything will get you killed


Received on Fri Oct 20 2006 - 07:24:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US