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

Create or Replace Procedure TRNC_TABLE (TAB_NAME IN VARCHAR2) AS   ch integer;
Begin

   ch := dbms_sql.open_cursor;
   dbms_sql.parse (ch,'truncate table '||tab_name,dbms_sql.v7); End;
/
SQL> SELECT COUNT(*) FROM STOCKS2;

 COUNT(*)                                                              
                            


---------                                                              

                            
      328                                                              
                            

SQL> EXECUTE TRNC_TABLE ('STOCKS2'); PL/SQL procedure successfully completed.

SQL> SELECT COUNT(*) FROM STOCKS2;

 COUNT(*)                                                              
                            


---------                                                              

                            
        0                                                              
 

SQL> SPOOL OFF Received on Sun Dec 15 1996 - 00:00:00 CST