Hi Aramirezjr,
When you tested the constraint that you posted here, did you do it against the call call_req table or the change table? The constraint that you posted has references to the change object, not the call request object, so I am not sure it would accept that.
As for the question of how you can allow the limited analyst to see tickets associated with CIs they are responsible for - there does not appear possible because you cannot cross objects in a data partition constraint. There would have to be an attribute within the object that you are putting the constraint on (requests or change orders etc.) that would be specific to those users, but there is no mechanism to check if they are responsible for a CI.
Hope this helps.
Jon I.