| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgres Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Must be owner to truncate? |
| Date: | 2005-07-07 20:58:03 |
| Message-ID: | 20050707205803.GL24207@ns.snowman.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
* Jim C. Nasby (decibel(at)decibel(dot)org) wrote:
> On Thu, Jul 07, 2005 at 01:48:59PM -0400, Tom Lane wrote:
> > I don't really agree with the viewpoint that truncate is just a quick
> > DELETE, and so I do not agree that DELETE permissions should be enough
> > to let you do a TRUNCATE.
>
> What about adding a truncate permission? I would find it useful, as it
> seems would others.
That would be acceptable for me as well. I'd prefer it just work off
delete, but as long as I can grant truncate to someone w/o giving them
ownership rights on the table I'd be happy.
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2005-07-07 21:27:13 | Re: Must be owner to truncate? |
| Previous Message | Ayush Parashar | 2005-07-07 20:55:55 | Multi-byte and client side character encoding tests for copy command.. |