> > 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. Andreas ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org