Re: How to prevent deletes when DELETE ANY TABLE granted?

From: John Verbil <jverbil_at_netmail.mnet.uswest.com>
Date: 1996/12/16
Message-ID: <32B5801C.2208@netmail.mnet.uswest.com>#1/1

> Todd is correct. dbms_sql is a *package*. You pass the DDL in as a
> string to its execute procedure. It will truncate tables, and perform
> any other DDL for that matter. It has been available since 7.1.3. Coding
> truncate inline doesnt work.

To the four of you who helped with the programmatic TRUNCATE issue: Todd, Geoff, Stephen, and P S,

Thanks for the help and clarification.

Learn something new every day! :)

-- 
John Verbil
U S WEST Communications
Information Technologies
jverbil_at_uswest.com
(303) 896-0916

Received on Mon Dec 16 1996 - 00:00:00 CST