BUG #2032: grant role bug

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.

Responses

Browse pgsql-bugs by date

  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