Skip site navigation (1) Skip section navigation (2)

Unusual permissions behaviour

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 (view raw or flat)
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


Responses

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2001-11-29 03:03:03
Subject: Re: 7.2beta3 on Digital Alpha
Previous:From: Christopher Kings-LynneDate: 2001-11-29 01:58:58
Subject: Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens up

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group