Re: BUG #2032: grant role bug

"Tom" <tom(dot)zschockelt(at)flender(dot)com> writes:
> 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;

Perhaps you meant to grant those select privileges to g_usermgr_use ?

Also, are you sure you were granting privileges on usermgr.a, and not
some other table named A in a different schema?

If you want us to believe this doesn't work, you'll need to send an
exact transcript of what you did (copy and paste from a terminal window
works well), not a rather handwavy description that might or might not
contain errors.

regards, tom lane