| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Unusual permissions behaviour |
| Date: | 2001-11-29 04:57:50 |
| Message-ID: | 14865.1007009870@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Why do I get a permission denied when I qualify the DELETE statement???
IIRC, you need SELECT permission to reference the values of any fields
of the table. If you don't have SELECT permission, the table should
be write-only to you; you shouldn't be able to learn things about its
contents by doing stuff like
begin;
delete from foo where col = 1;
-- observe # rows deleted
rollback;
-- now I know whether there is a row with col = 1
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2001-11-29 05:02:45 | Re: Second call for platform testing |
| Previous Message | Joe Conway | 2001-11-29 04:48:39 | 7.2b3 pg_dump, general 7.2b3 comments |