Re: guideline for creating temporary (working) table

From: DJ <nospamplease_at_goaway.com>
Date: Sun, 1 Feb 2004 13:39:22 -0000
Message-ID: <fk7Tb.14978$YV1.1015@newsfep4-winn.server.ntli.net>

"Ed Avis" <ed_at_membled.com> wrote in message news:l1n083kmne.fsf_at_budvar.future-i.net...
> 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>

but with delete from <table> I can then do

ROLLBACK :-) Received on Sun Feb 01 2004 - 07:39:22 CST