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

Mixed PERMISSION GRANTS ----------------------- Key: TEIID-5798 URL: https://issues.jboss.org/browse/TEIID-5798 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Christoph John Assignee: Steven Hawkins Priority: Major Fix For: 13.1 Original Estimate: 6 hours Time Spent: 4 hours Remaining Estimate: 1 day, 6 hours 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. {code} 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; {code}