Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!bcklog1.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Fri, 07 Jul 2006 11:59:14 -0500 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.misc References: <44ae7817$0$26254$9b4e6d93@newsread2.arcor-online.net> <44ae7c24$0$29129$9b4e6d93@newsread4.arcor-online.net> Subject: Re: PL/SQL Package Date: Fri, 7 Jul 2006 12:59:06 -0400 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Message-ID: Lines: 37 NNTP-Posting-Host: 68.57.99.188 X-Trace: sv3-zZKGjffju5hWmqhyg6/myY3iuMX1rfBAcGPc3sKjVSOkC7FYAWgFMcc9JBJwOgk1gR7AOVqfQvDFzRz!gdGdeYHrZpJevk/hsQdT+vr5Dm4JTSR929RiOUgAGAuFxzj6Fpb7FX1jT5VKUApqd5DOaS2556sO!Q2zsZ/K3uZnY1bk= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:128374 "Christian Schneider" wrote in message news:44ae7c24$0$29129$9b4e6d93@newsread4.arcor-online.net... :> CREATE OR REPLACE PACKAGE XXXX ... : > : > GRANT EXECUTE ON XXXX TO ... : > : : I know those commands seperately - I just never used them in combination : - And I don't get the point - : How does this work, then? : : How do you use the package, or the "grant"??? : : Lets say, I have a user and want to give him the right to do all the : things that are granted in the package, or just certain things of the : package - how do I do this??? : : : Thanks, : : Chris GRANT EXECUTE allows the grantee to run any public procedure or function contained in the package (ie, those procedures that have their specification included in the package specification) So, you create a package (and a package body, of course), then grant execute on the package to the user(s) or role(s), and they then make calls to the package from their PL/SQL code (or anonymous blocks). You cannot grant execute on portions of the package -- it's all or none. ++ mcs