Uploaded image for project: 'Sentry (Retired)'
  1. Sentry (Retired)
  2. SENTRY-2151 Automatically derive owner privileges from Hive Object Ownership
  3. SENTRY-2245

Remove privileges that do not associate with a role or a user

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • None
    • None

    Description

      After a privilege is detached from a role or a user, we should check if this privilege is not associated with any role nor any user. Then, we should remove this privilege from DB. Otherwise, the orphan privileges will grow overtime.

      One example place is in alterSentryRoleGrantPrivilegeCore. After removing role from mInsert, this privilege may not be associated with any role or user, and should be removed.

      Attachments

        1. SENTRY-2245.003.patch
          5 kB
          Na Li
        2. SENTRY-2245.004.patch
          5 kB
          Na Li
        3. SENTRY-2245.005.patch
          10 kB
          Na Li
        4. SENTRY-2245.006.patch
          9 kB
          Na Li
        5. SENTRY-2245.006.patch
          9 kB
          Na Li

        Issue Links

          links to

          Web Link Review Link for this case

          Activity

            People

              linaataustin Na Li
              linaataustin Na Li
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: