How can I check to see who has the Timesheet approval right in Clarity PPM at either the global or instance level?
This can help in particular if some users are getting notifications to approve timesheets unexpectedly, which can happen if they have timesheet - approval rights to the resource. (See KB000021294 for more details on this issue)
Note: If you go to the Full View link on the access to this resource tab, it may help point to who has the right through a global right, but if there is a large number this may not help as it doesn't specify what rights they have to the resource there.
3. Additionally, for On Premise customers, here are a couple of queries that can help:
Timesheet global query:
SELECT RES.UNIQUE_NAME, 'HAS INSTANCE RIGHTS TO' AS RIGHT_TYPE, PERM.OBJECT_INSTANCE_ID
WHERE PERM.PERMISSION_CODE = 'prApproveActuals'
AND PERM.COMPONENT_CODE = 'PRJ'
AND PERM.OBJECT_CODE = 'PRJ_RESOURCE'
AND PERM.OBJECT_TYPE = 'RECORD'
AND PERM.USER_ID = RES.ID
SELECT CMN_SEC_USERS.USER_NAME, 'GLOBAL', -9999 --- global right query
FROM CMN_SEC_USER_R_V, CMN_SEC_USERS
WHERE PERMISSION_CODE = 'APPROVE'
AND USER_ID = CMN_SEC_USERS.ID
AND OBJECT_ID IN
WHERE OBJECT_CODE = 'TMS_TIMESHEETS'
AND OBJECT_TYPE_ID = 6
Instance level query:
P.USER_ID, P.USER_NAME TS_APPROVER, P.OBJECT_INSTANCE_ID,
srmr.unique_name TS_SUBMITTER, srmr.last_name, srmr.last_name
and SRMR.id = OBJECT_INSTANCE_ID
--and P.USER_NAME in ('admin')
AND P.PERMISSION_CODE = 'prApproveActuals'