From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Unusual permissions behaviour |
Date: | 2001-11-29 02:59:04 |
Message-ID: | GNELIHDDFBOCMGBFGEFOKEJKCAAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I have this problem in 7.1.3 - I can't confirm at the moment if it exists in
7.2.
I have already granted the 'au-dietclub' user delete and insert permissions
on the users_flags table at this point:
australia=> delete from users_flags;
DELETE 0
australia=> delete from users_flags where user_id=1;
ERROR: users_flags: Permission denied.
australia=> \connect - chriskl
You are now connected as new user chriskl.
australia=# grant select on users_flags to "au-dietclub";
CHANGE
australia=# \connect - au-dietclub
You are now connected as new user au-dietclub.
australia=> delete from users_flags where user_id=1;
DELETE 0
Why do I get a permission denied when I qualify the DELETE statement???
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2001-11-29 03:03:03 | Re: 7.2beta3 on Digital Alpha |
Previous Message | Christopher Kings-Lynne | 2001-11-29 01:58:58 | Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens up |