Re: drop any table vs. delete any table

If you don't like granting such privileges, you can encapsulate the truncate statements into a stored procedure, and simply grant EXECUTE

CREATE OR REPLACE PROCEDURE sp__trunc_tabs AS

cursor_1 integer;
ignore integer;

BEGIN

• open a cursor

   cursor_1 := dbms_sql.open_cursor;

• repeat the following two lines for each table that must be truncated
• changing 'tb__junk' to the correct table name

   dbms_sql.parse(cursor_1,'truncate table tb__junk',dbms_sql.v7);    ignore := dbms_sql.execute(cursor_1);

• close the cursor

   dbms_sql.close_cursor(cursor_1);

END;
/ Received on Fri Feb 27 1998 - 00:00:00 CST