Re: Regarding TODO item "%Add a separate TRUNCATE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regarding TODO item "%Add a separate TRUNCATE
Date: 2006-04-26 17:45:53
Message-ID: 19648.1146073553@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gevik Babakhani <pgdev(at)xs4all(dot)nl> writes:
> Would the privilege apply to the table depending on the table being
> truncated?

I think the idea is to require TRUNCATE privilege on all the tables
being truncated in the command. This would substitute for the existing
ownership check.

I do have a concern here, which is that GRANT ALL on a table didn't use
to convey TRUNCATE, but now it will. However, since GRANT ALL does
confer the right to do "DELETE FROM tab", maybe this isn't an issue.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-04-26 17:54:26 Re: Regarding TODO item "%Add a separate TRUNCATE permission"
Previous Message Stephen Frost 2006-04-26 17:45:25 Re: Regarding TODO item "%Add a separate TRUNCATE permission"