permission errors - Mailing list pgsql-novice

From Noah Roberts
Subject permission errors
Date
Msg-id 3B780DBA.CB4096FA@foxinternet.net
Whole thread Raw
Responses Re: permission errors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I have granted the user UPDATE permission on this table several times.
I check the perms and they look right.  I cannot update the hit_count of
the link table as user 'masks'.

Oddity 2 - I created these tables as masks_adm.....as you can see below
that is the owner....yet I frequently got permission denied errors when
I tried to do things to these tables and had to actuall grant myself
permission to access them.  It appears that this only happens when I
grant someone else permissions on the tables because the others work
just fine.


here is my \d:

masks=> \d
             List of relations
        Name         |   Type   |   Owner
---------------------+----------+-----------
 access              | table    | masks_adm
 access_key_seq      | sequence | masks_adm
 administrator       | table    | masks_adm
 enews_subscription  | table    | masks_adm
 enewsletter         | table    | masks_adm
 enewsletter_key_seq | sequence | masks_adm
 link                | table    | masks_adm
 link_category       | table    | masks_adm
 link_edit_req       | table    | masks_adm
 link_key_seq        | sequence | masks_adm
 masks_user          | table    | masks_adm
(11 rows)

here is the permissions -
         Access permissions for database "masks"
      Relation       |        Access permissions
---------------------+-----------------------------------
 access              |
 access_key_seq      |
 administrator       |
 enews_subscription  |
 enewsletter         |
 enewsletter_key_seq |
 link                | {"=","masks=arw","masks_adm=arw"}
 link_category       | {"=","masks=r","masks_adm=arw"}
 link_edit_req       |
 link_key_seq        | {"=","masks=rw","masks_adm=w"}
 masks_user          | {"=","masks=r"}

Here is the command and the result:
masks=> update link set hit_count=1 where key=192;
ERROR:  masks_user: Permission denied.



pgsql-novice by date:

Previous
From: David Mulcahy
Date:
Subject: Foreign Key problem
Next
From: Tom Lane
Date:
Subject: Re: permission errors