[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.0 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;