Re: Truncate Permission

* Zeugswetter Andreas ADI SD (ZeugswetterA@spardat.at) wrote:
>
> > > Wouldn't it be far more logical to decide that if a user has the
> > > permissions to do a DELETE FROM table; then they have permission to
> do
> > > a TRUNCATE? Why make an additional permission?
> >
> > Truncate doesn't fire ON DELETE triggers.
>
> Yes, but it would imho be ok if there are'nt any on delete triggers on
> the table.

Nope, it doesn't follow MVCC rules properly either.  It really needs to
be a seperate permission.
Thanks,
    Stephen