Re: Truncate table and Triggers

From: Zatherus <zatherus_at_theriver.com>
Date: Tue, 09 Jan 2001 06:50:37 GMT
Message-ID: <qucl5tkkkndun15hbs1f1i8p3nfpsum2rc@4ax.com>

On Mon, 1 Jan 2001 22:09:23 +0100, "Nicolas Bronke" <newsgroup_at_trinity.de> wrote:

>I placed a delete trigger on a table to unpermit delete operations under a
>special condition.
>
>Now I fpund out, that truncate table ommit this rules. Everything is erased
>nevertheless from the rules.
>
>Perhaps it is logically, but how can I avoid this situation?
>
>regards
>Nicolas
>

The Truncate command is what is known as a DDL (Data Definition Language) not a DML (Data Maniplulation Language) command. If I am not mistaken, DDL does not fire ANY triggers where DML will. Like the other gentleman said, it is a privlege issue. The owner of the table can do what they want with it, but others have to be given permisions. If you don't give others the permission to trucate, drop or delete from a table, they cannot. Received on Tue Jan 09 2001 - 00:50:37 CST