BUG #2032: grant role bug
От | Tom |
---|---|
Тема | BUG #2032: grant role bug |
Дата | |
Msg-id | 20051109124400.0B975F0F59@svr2.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #2032: grant role bug
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 2032 Logged by: Tom Email address: tom.zschockelt@flender.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.
В списке pgsql-bugs по дате отправления: