From: | Noah Roberts <jik(at)foxinternet(dot)net> |
---|---|
To: | psql <pgsql-novice(at)postgresql(dot)org> |
Subject: | permission errors |
Date: | 2001-08-13 17:26:20 |
Message-ID: | 3B780DBA.CB4096FA@foxinternet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-13 18:30:49 | Re: permission errors |
Previous Message | David Mulcahy | 2001-08-13 16:57:49 | Foreign Key problem |