dynamobi/dynamobi — Issue #40: [DDB-35] Permissions of role do not carry through to user
Author: dynamobi-build
Created: 2011-12-30 01:51:17+00:00
State: open
Labels: DDB

[reporter="ksecretan", 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.