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
PostGreSQL user/group permission problems
Moderator: General Moderators
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
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