Jach/testr — Issue #20: [DDB-35] Permissions of role do not carry through to user
Author: Jach
Created: 2011-12-29 22:38:25+00:00
State: open

[created="Tue, 6 Jul 2010 12:34:35 -0700"]

I could just be doing something stupid, however:

(As user U2):

SELECT * FROM "garbage".hello;

Error: Privilege "SELECT" required for access to table "garbage"."HELLO" (state=,code=0)

(As user sa):

CREATE ROLE xyz;

GRANT SELECT ON "garbage".hello TO xyz;

GRANT ROLE xyz TO U2;

(As user U2):

Same as above.

(As user sa):

GRANT SELECT ON "garbage".hello TO U2;

(As user U2):

Select query executes without error.