Re: Truncate table and Triggers

> >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?
> >
> 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.

Thank you. That makes more clear.

Regards
Nicolas Received on Tue Jan 09 2001 - 04:09:46 CST