Re: [HACKERS] Truncate Permission

[Stephen Frost]

* Zeugswetter Andreas ADI SD ([EMAIL PROTECTED]) 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

signature.asc
Description: Digital signature