From: | Eric D Nielsen <nielsene(at)MIT(dot)EDU> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Permissions with multiple groups... |
Date: | 2002-09-18 17:09:44 |
Message-ID: | 200209181709.NAA19913@magic-pi-ball.mit.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm receiving permissions denied message when I think I shouldn't.
I have three users cib_unauth, cib_auth, and cib_admin.
I have two groups cib_all and cib_trusted. The first group contains
all the users, the second group contains the latter two.
I'll grant permissions like
REVOKE ALL ON sometable FROM PUBLIC;
GRANT SELECT ON sometable TO GROUP cib_all;
GRANT INSERT ON sometable TO GROUP cib_trusted;
GRANT UPDATE,DELETE on sometable TO cib_admin;
However I'm getting permission denied messages on sometable when I'm issueing
selects as cib_admin.
\dp sometable
sometable | {"=","nielsene=arwR","cib_admin=w","group cib_all="r","group cib_trusted=a"}
Connecting as cib_auth has the same problem, but connecting as cib_unauth
works.
I haven't found anything in the documentation about problems with a user being
a member of two groups. However, I suspect I might be slightly abusing
user groups?
Eric
From | Date | Subject | |
---|---|---|---|
Next Message | Cindy | 2002-09-18 18:12:57 | posix style regexp? |
Previous Message | Barry Lind | 2002-09-18 17:08:14 | Re: [GENERAL] Postgres 7.3b1 + JDBC3 (2002-09-05) truncates SQL |