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

Mixed PERMISSION GRANTS

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 13.1
    • Component/s: Query Engine
    • Labels:
      None
    • Sprint:
      DV Sprint 60
    • Story Points:
      3
    • Affects:
      Documentation (Ref Guide, User Guide, etc.), Release Notes
    • Estimated Difficulty:
      Medium

      Description

      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;
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  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