Re: execute oracle 8i supplied package

A copy of this was sent to candidenewbie_at_my-deja.com (if that email address didn't require changing) On Wed, 01 Dec 1999 17:56:16 GMT, you wrote:

>hi all,
>
>is it enough to execute catproc.sql in order to use dbms_alert package
>and dbms_lock?
>or do i need to grant execute on this package too?
>I know this question seems simple but i come from another database
>world.
>

for those 2 packages in particular, you need to grant execute on them. they are among the packages that are not granted to public (as they can do some powerful things)

>thanks for your reply.
>
>candide
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Dec 01 1999 - 13:15:39 CST