Orphaned instance rights after deleting a portlet page
search cancel

Orphaned instance rights after deleting a portlet page


Article ID: 272712


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


Deleting a portlet page that a group has Instance Rights leaves orphaned records in the database.

Steps to Reproduce:

  1. Create a new group.
  2. Create a new portlet page (an empty page is fine).
  3. Assign Instance Rights to this page to the group (Portlet Page object, Page - View right).
  4. Go to Administration > Organization and Access > Groups > [group] > Group's Access Rights > Instance > Page - View, and check the URL:
  5. Run the following DB query with the id from the previous URL:
    select * from cmn_sec_assgnd_obj_perm

    where upper(principal_type) = 'GROUP'

    and principal_id = 5004264
  6. Delete the portlet page from Step 2
  7. Check the Portlet Page / Page - View rights for the group - "There are no items to display" (expected).
  8. Run the query from Step 5 again.

Expected Results: The query does not return any results.

Actual Results: The query still returns the Page - View instance right.


Release : 16.0.2




This issue is currently under review.