Page 1 of 1

PostGreSQL user/group permission problems

Posted: Wed Sep 18, 2002 1:09 pm
by nielsene
I'm receiving a permission denied message when I try to select on certain tables as cib_admin_user.

\dp tablename yields
tablename | {"=","nielsene=arwR","cib_admin_user=w","group cib_all=ar","group cib_trusted=w"}

cib_admin_user is a member of both groups on that line, so it should be inheiriting the 'r'(read/SELECT) permission from cib_all.

cib_auth_user is also a member of both groups and it is behaving properly.

Anyone have any advice?

Eric

Posted: Wed Sep 18, 2002 3:21 pm
by nielsene
A quick followup, as a test I tried
GRANT SELECT ON tablename TO cib_admin_user;

cib_admin_user can now SELECT from tablename, so this is a work around (go through and grant SELECT (and Insert,Update,Delete as appropriate) to all the tables, but it shouldn't be needed. cib_auth_user has no troubles and its doing almost the same thing. <sigh>

Anyways if anyone has any advice I'ld still love to hear it, but I know there aren't a lot of PostGreSQL users here... the postgres mailing lists have bee very quiet today, so that hasn't helped.

Eric