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

From: John Verbil <jverbil_at_netmail.mnet.uswest.com>
Date: 1996/12/12
Message-ID: <32B05664.165A@netmail.mnet.uswest.com>#1/1

Todd Verstraten wrote:
>
> Does TRUNCATE not work in DBMS_SQL? I have tried many other DDL statements
> that have worked bu not truncate.

It doesn't. I've tried it in the past and, just to be sure, tried it again today. You'll get the following message when you try to compile your procedure:

truncate table replica;

         *
ERROR at line 2:

ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "TABLE" when expecting one of the
following:

:= . ( @ % ;
The symbol ":= was inserted before "TABLE" to continue.

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

Received on Thu Dec 12 1996 - 00:00:00 CST