Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!newscon06.news.prodigy.com!prodigy.net!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 10:07:40 -0500 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.misc References: <44ae7817$0$26254$9b4e6d93@newsread2.arcor-online.net> Subject: Re: PL/SQL Package Date: Fri, 7 Jul 2006 11:07:39 -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: 28 NNTP-Posting-Host: 68.57.99.188 X-Trace: sv3-Y0MHpFtt+cwIe9II+T36eeGJLLTm5oqiqhMFKEW9T8uj4kKuzNNByTTsAVjsSFu6tFgQG941g6/9aqj!bfJ0apRYjsvJhClGgKu9VQ8YDw1menbt7dY1SQj6G1ABwhs1b76G7uz26nZOtccPy4163Esg2NB0!fM9judX4frPEE78= 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:128371 "Christian Schneider" wrote in message news:44ae7817$0$26254$9b4e6d93@newsread2.arcor-online.net... : Hi, : : I have to create a package that "contains" the accesses to : insert, delete, update, select on a certain table (Lets say "myTable") : : Sorry, can you give me a hint? I don't really grasp what they want me to : do - I can create users and grant them the right to do an insert, : delete, update or select on a certain table - : but how can I do the above???? : : : Thanks in advance, : : Chris : How familiar are you with the commands: CREATE OR REPLACE PACKAGE XXXX ... GRANT EXECUTE ON XXXX TO ... ++ mcs