Re: [SQL] truncating table permissions

2005-03-04 Thread Tom Lane
"Lynwood Stewart" <[EMAIL PROTECTED]> writes: > I was expecting "truncate table " to truncate a table if I had > delete permissions. This does not appear to be the case. No, TRUNCATE is restricted to the table's owner, regardless of any grantable permissions. This was (ahem) inadequately docume

Re: [SQL] truncating table permissions

2005-03-04 Thread Keith Worthington
Lynwood Stewart wrote: I was expecting "truncate table " to truncate a table if I had delete permissions. This does not appear to be the case. Would someone confirm this for me, or let me know what I am doing wrong. This is the case. You are not doing anything wrong. There was a discussion

[SQL] truncating table permissions

2005-03-04 Thread Lynwood Stewart
I was expecting "truncate table " to truncate a table if I had delete permissions. This does not appear to be the case. Would someone confirm this for me, or let me know what I am doing wrong. -- Lyn ---(end of broadcast)--- TIP 2: you can ge