Orphaned instance rights after deleting a portlet page
book
Article ID: 272712
calendar_today
Updated On:
Products
Clarity PPM On PremiseClarity PPM SaaS
Issue/Introduction
Deleting a portlet page that a group has Instance Rights leaves orphaned records in the database.
Steps to Reproduce:
Create a new group.
Create a new portlet page (an empty page is fine).
Assign Instance Rights to this page to the group (Portlet Page object, Page - View right).
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
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
Delete the portlet page from Step 2
Check the Portlet Page / Page - View rights for the group - "There are no items to display" (expected).
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.