AnsweredAssumed Answered

Security Context Issue

Question asked by Velita Wheeler on Dec 28, 2017
Latest reply on Jan 10, 2018 by Velita Wheeler

Hello Everyone!

From what I've gathered from documentation and previous threads on here, the custom Security Context file I've created should work for all entries listed...But it does not work for Other Business Owner and Backup Technical Owner...Any ideas why?

 

 

SECURE_OBJECT_TYPE,NAME,ACTION,IMPLICIT_HAS_QUERY,IMPLICIT_BS_CHANGE,IMPLICIT_BU_CHANGE,SCOPE_TABLE,SCOPE_FILTER
Application,Business Owner,View,,scope,,t_applications,business_owner=${id} and resource_type='A' and is_deleted='FALSE'
Application,Technical Owner,View,scope,,,t_applications,technical_owner=${id} and resource_type='A' and is_deleted='FALSE'
Application,Backup Business Owner,View,,scope,,t_applications,cau1=${id} and resource_type='A' and is_deleted='FALSE'
Application,Backup Technical Owner,View,,scope,,t_applications,cau2=${id} and resource_type='A' and is_deleted='FALSE'
Application,Other Business Owner,View,,,,t_applications,scope.id in (select sv.reference_id from v_av_security_values sv where sv.reference_key='APP_OBO' and sv.user_id=${id})
Application,Other Technical Owner,View,,,,t_applications,scope.id in (select sv.reference_id from v_av_security_values sv where sv.reference_key='APP_OTO' and sv.user_id=${id})

 

 

 

Thanks!

Outcomes