AnsweredAssumed Answered

Resource Viewer Rights

Question asked by navzjoshi00 Champion on Aug 29, 2011
Latest reply on Aug 29, 2011 by Chris_Hackett
Security condition for project viewer is
EXISTS ( SELECT 1
FROM CMN_SEC_ASSGND_OBJ_PERM_R_V, CMN_SEC_USERS
WHERE CMN_SEC_ASSGND_OBJ_PERM_R_V.OBJECT_TYPE = 'RECORD'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.OBJECT_CODE = 'PRJ_PROJECT'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.PERMISSION_CODE IN ('prProjectViewer')
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.COMPONENT_CODE = 'PRJ'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.USER_ID = CMN_SEC_USERS.id
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.USER_ID = @Prompt('User ID', 'N',, mono, free) )

Instance Project viewer
EXISTS (
SELECT 1
FROM cmn_sec_assgnd_obj_perm_v
WHERE object_instance_id = @Select(Projects\Project DB Id)
AND object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code IN ('prProjectViewer')
AND component_code = 'PRJ'
AND user_id = @Prompt('User ID', 'N',, mono, free)
)



I have implemented the same logic for Resource viewer .
EXISTS (SELECT 1
FROM CMN_SEC_ASSGND_OBJ_PERM_R_V, CMN_SEC_USERS
WHERE CMN_SEC_ASSGND_OBJ_PERM_R_V.OBJECT_TYPE = 'RECORD'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.OBJECT_CODE = 'PRJ_RESOURCE'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.PERMISSION_CODE IN ('ResourceView')
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.COMPONENT_CODE= 'PRJ'
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.USER_ID = CMN_SEC_USERS.id ( Is this join right?? or Do I need to join it with SRM_resources user_id)
AND CMN_SEC_ASSGND_OBJ_PERM_R_V.USER_ID= @Prompt('User ID', 'N',, mono, free) )

Instance Resource viewer.

EXISTS (
SELECT 1
FROM cmn_sec_assgnd_obj_perm_v
WHERE object_instance_id = @Select(Resources\Resource DB Id)
AND object_type = 'RECORD'
AND object_code = 'PRJ_RESOURCE'
AND permission_code IN ('ResourceView')
AND component_code = 'PRJ'
AND user_id = @Prompt('User ID', 'N',, mono, free)
)


Project viewer rights are working fine, while Resource Viewer are not. A quick response would be much appreciated

NJ

Outcomes