Clarity: Missing 'Resource - Self (Auto)' instance right when creating a new resource.

Document ID : KB000051631
Last Modified Date : 14/02/2018
Show Technical Document Details



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'','|| || ');' from cmn_sec_users u, srm_resources r
   where r.user_id =
   and 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 =

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',
  1. Run all the stored procedures statements returned by the first.
  2. 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.