From: | "Tom" <tom(dot)zschockelt(at)flender(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2032: grant role bug |
Date: | 2005-11-09 12:44:00 |
Message-ID: | 20051109124400.0B975F0F59@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2032
Logged by: Tom
Email address: tom(dot)zschockelt(at)flender(dot)com
PostgreSQL version: 8.1
Operating system: win2k
Description: grant role bug
Details:
I've two login-roles ( usermgr, enduser ) each with a separate schema. I
want to grant privileges on schema usermgr and some of it's objects to a
group-role 'g_usermgr_use'.
(user = usermgr )
GRANT usage on SCHEMA usermgr to g_usermgr_use;
GRANT select on table a to g_usermgr;
GRANT select on table b to g_usermgr;
now I grant the group-role 'g_usermgr_use' to my login-user 'enduser'.
GRANT g_usermgr_use to enduser;
now I tried a select on one of the tables
user = enduser
select * from usermgr.a;
Here I got the following error message :
ERROR: permission denied for schema usermgr
Then I tried a
user = usermgr
GRANT usage on SCHEMA usermgr to enduser;
and again a
user = enduser
select * from usermgr.a;
now I got the following error
ERROR: permission denied for relation a
It seems that the group-role permissions do not work
properly.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-09 14:25:25 | Re: Postgres8.0.4 install problem |
Previous Message | Mark Gibson | 2005-11-09 12:06:30 | BUG #2031: Patch also required prior to ML3 |