Re: guideline for creating temporary (working) table

rgaffuri_at_cox.net (Ryan Gaffuri) writes:

>Reason for not having truncate in production is because you might
>truncate the wrong table.

This doesn't make any sense. If you have delete permission on a table, then it is equally easy to 'delete from wrong_table'. To protect against such mistakes you'd have to deny permission for both delete and truncate. There may be good reasons to grant one and not the other, but avoiding such mistakes is not one of them.

-- 
Ed Avis <ed_at_membled.com>