PostGreSQL user/group permission problems
Posted: Wed Sep 18, 2002 1:09 pm
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
\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