The "Resource - Self (Auto)" is an instance right assigned automatically when the user is created. This right is automatically granted to the resource. This right includes the Resource - Edit Ideas access right.
Once the resource is created using Clarity UI, if there is any XOG performed on this resource with "Trackmode" = "None", that might delete the "Resource-Self" right from the resource's rights.
Expected Result: Resource has "Resource-Self (Auto)" instance right.
Actual Result: Resource is missing "Resource-Self (Auto)" instance right.
In order to re-establish the missing "Resource-Self (Auto)" instance right, run the following query against the Database.
select 'exec cmn_sec_assign_inst_right_sp ( ''USER'', '''||user_name||''',
''ResourceSelf'','|| r.id || ');' from cmn_sec_users u, srm_resources r
where r.user_id = u.id
and u.id not in (select csaop.principal_id
from cmn_sec_assgnd_obj_perm csaop, cmn_sec_groups g
where g.group_code = 'ResourceSelf'
and csaop.principal_type = 'USER'
and csaop.right_id = g.id)
The output the query above will return stored procedure statements for users missing the "Resource - Self (auto)" instance right.
Below is an example of the output.
exec cmn_sec_assign_inst_right_sp ( 'USER', 'username',
- Run all the stored procedures statements returned by the first.
- Commit the changes.
This issue has been documented as CLRT-56179 and is assigned to development for review. If you are experiencing this problem and the workaround above does not significantly help, please contact CA Clarity Support.
Keywords: CLARITYKB, CLRT-56179, Clarity12open, Clarity8open, xml open gateway, resource, auto, instance, right.