[teiid-issues] [JBoss JIRA] (TEIID-5798) Bug in PERMISSION GRANTS

[Christoph John (Jira)]

Christoph John created TEIID-5798:
-------------------------------------

             Summary: Bug in PERMISSION GRANTS
                 Key: TEIID-5798
                 URL: https://issues.jboss.org/browse/TEIID-5798
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 13.0
            Reporter: Christoph John
            Assignee: Steven Hawkins


Hello,
I am currently trying to set a set of permissions on a table/view. Hence a condition on INSERT,UPDATE,DELETE and an unconditioned SELECT.
However, it seems that conditioned and unconditioned GRANT statements do not work together.

GRANT INSERT,UPDATE,DELETE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" CONDITION 'UserDefinedProducts_SRC.fkProfile in  (SELECT Account.idProfile FROM Account WHERE Account.uuidUser = LEFT(user(), 36) )' TO odata;

GRANT SELECT ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" TO odata;

REVOKE ALTER,EXECUTE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" FROM odata;



--
This message was sent by Atlassian Jira
(v7.12.1#712002)