BUG #2032: grant role bug

Поиск
Список
Период
Сортировка
От Tom
Тема BUG #2032: grant role bug
Дата
Msg-id 20051109124400.0B975F0F59@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2032: grant role bug  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Mark Gibson"
Дата:
Сообщение: BUG #2031: Patch also required prior to ML3
Следующее
От: "Antonio"
Дата:
Сообщение: BUG #2029: Error descriptions appear untranslated