Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-16862

Database space leak in ResourcePermission table after role deletion

    Details

      Description

      It is possible to have 'unused' records in ResourcePermission table after deleting a role.

      Steps to reproduce:

      1. create ordinary role e.g. testrole1
      2. upload e.g. file1 into document library
      3. permit some actions on file1 for testrole1
      4. delete testrole1

      After deletion in ResourcePermission table there is a record with roleId of deleted testrole1 . This record will remain until file1 is deleted.
      This can cause also NoSuchRoleException when retrieved role if used roleId from ResourcePermission

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sophia.zhang Sophia Zhang
              Reporter:
              wojciech_zalecki Wojciech Zalecki (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 4 weeks, 6 days ago

                  Packages

                  Version Package
                  6.0.X EE
                  6.1.1 CE GA2
                  6.1.20 EE GA2
                  6.2.0 CE M2