Re: Granting Execute on Packages to other users

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 30 Jul 2004 06:38:04 +0200
Message-ID: <44kjg0lmdjuv5a6ujvdibjug1bre67bd9n@4ax.com>

On Fri, 30 Jul 2004 03:40:57 GMT, "Jawahar Rajan" <jrajan_at_nc.rr.com> wrote:

>When I grant execute on a package ot a user is iti enough ot grant just as
>"Grant Execute on PKG_Test to user1"
>Do i need to repaet this for the Package Body? The reason I askis because
>when I log in a user1 and look at th ePackages I only see the pakcage Spec
>there is nothing in the package body (I am using Toad)
>
>Any help is appreciated
>
>Jawahar
>

a grant execute on <package> is sufficient

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Jul 29 2004 - 23:38:04 CDT