Uploaded image for project: 'Sentry'
  1. Sentry
  2. SENTRY-302

Partial revoke on Table fails if both ALL and a SELECT/INSERT grant exists

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 1.4.0
    • Component/s: None
    • Labels:

      Description

      Test case to show when revoke does not work :

      1. Create 1 Role (user_role & user_role2)
      2. Create a Table t1
      3. grant ALL on t1 to user_role
      4. grant INSERT on t1 to user_role1
      5. Revoke INSERT on t1 from user_role
           - This would imply user_role can still SELECT
           - But user_role should NOT be allowed to LOAD
      6. Observed that INSERT is still allowed on table
      

        Attachments

        1. SENTRY-302.test.patch
          3 kB
          Arun Suresh

          Issue Links

            Activity

              People

              • Assignee:
                asuresh Arun Suresh
                Reporter:
                asuresh Arun Suresh
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: