From: John Verbil Subject: Re: How to prevent deletes when DELETE ANY TABLE granted? Date: 1996/12/12 Message-ID: <32B033D8.3674@netmail.mnet.uswest.com>#1/1 references: <199612112150.QAA24773@dub-gw-1.compuserve.com> to: Todd Verstraten content-type: text/plain; charset=us-ascii organization: U S WEST Information Technologies - IAD mime-version: 1.0 newsgroups: comp.databases.oracle.server x-mailer: Mozilla 3.0 (X11; I; HP-UX B.10.10 9000/712) Todd Verstraten wrote: > > What about creating a stored procedure to do the truncation and NOT > granting delete any table. Then you can grant execute as needed and get a > degree of control within the proc. > > Todd Verstraten > mailto:tverstrat@tier3.com > http://www.tier3.com I liked your idea of an essentially declarative method rather than procedural, but unfortunately, two problems crop up with this idea: 1. You cannot to TRUNCATEs in PL/SQL, only SQL*Plus (at least on 7.2.3) 2. Even if you could, the person executing the stored procedure must have DELETE ALL TABLE in order to do a TRUNCATE. Thanks for your idea, though. I ended up using the idea of another respondant, a copy of which is posted to the newsgroup under a separate article. -- John Verbil U S WEST Communications Information Technologies jverbil@uswest.com (303) 896-0916