Manage User Access saved query issue
Hi ,
I am looking for restricting the user from performing the rerate and redrive action wherein user is having the Dispatcher qualifier as involved party .
I am using the below saved query but that does not fetch the user name in run time in the saved condition.
SELECT 1 FROM SHIPMENT_INVOLVED_PARTY SIP
, SHIPMENT S WHERE SIP.SHIPMENT_GID = S.SHIPMENT_GID
AND SIP.INVOLVED_PARTY_QUAL_GID = 'DSC.DISPATCHER'
AND SIP.INVOLVED_PARTY_CONTACT_GID = SYS_CONTEXT('GLOG_USER_CTX','LOG_IN_USER_GID') and S.SHIPMENT_GID = ?
also used the below
SELECT S.SHIPMENT_GID
FROM SHIPMENT S
0