Orphaned instance rights after deleting a portlet page
search cancel

Orphaned instance rights after deleting a portlet page

book

Article ID: 272712

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

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:
    <server>/niku/nu#action:nmc.groupInstanceRightsAssociations&id=5004264&rightId=50183&rightType=CMN_PAGES&isClassRight=false
  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.

Environment

Release : 16.0.2

Resolution

DE77440, fixed in 16.2.0