Permissions with multiple groups...

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

Responses

Browse pgsql-general by date

  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