Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5798

Mixed PERMISSION GRANTS

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 13.1
    • None
    • Query Engine
    • None
    • DV Sprint 60
    • 3
    • Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Medium

      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;

              rhn-engineering-shawkins Steven Hawkins
              cjohn001 Christoph John (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 6 hours Original Estimate - 6 hours
                  6h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 3 hours
                  2d 3h