Hi, There are some system security views rights(cmn_sec_assgnd_obj_perm_r_v).you can use them to restrict the Data in reports.In the clarity out of the box reports,if you have the permission to view the sql,then have an look.You need to pass the userid (Dave mentioned it) in the sql query of the procedure(oracle). Below is an sample query.(7.5.2) Your query...and user id in ( SELECT user_id FROM cmn_sec_assgnd_obj_perm_r_v
WHERE object_type = 'RECORD' AND object_code = 'PRJ_PROJECT'
AND permission_code IN
(
'ProjectViewAccounting',
'ProjectEditAccounting'
)
AND component_code = 'PRJ'
AND user_id = UserId (Pass the userid) ) As this is an custom report,you need to pass the userid.Pls also go through the thread which is a little related to your question.
http://caforums.ca.com/ca/board/message?board.id=CAClarityGeneralDiscussion&thread.id=4168 cheers,sundar