Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/24/2024 03:49 AM
HI Team,
we need the correct access query for users can see the 2 endpoints tile if they don't have the access to both. If they have access to anyone then endpoints tile should not be visible to that user even if either of the endpoint tile is in process of ARS.
Access query which we are using.
where users.userkey in (select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey NOT IN ('17','22')))
05/24/2024 04:51 AM
Hi @asharma ,
where users.userkey not in (select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey in ('17','22')))
If this helps your question, please consider selecting Accept As Solution and hit Kudos
05/24/2024 05:20 AM - edited 05/24/2024 05:20 AM
@asharma ,
I guess, the above query should be applied in both endpoint (17 and 22) access query filter.
05/24/2024 05:38 AM
Put this query in access query filter of both EP
where users.userkey not in (select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey in ('17','22')))
05/24/2024 05:41 AM
will this also take care if request is in progress and user will not be able to see any tile for both endpoint?
05/24/2024 05:48 AM
For new request.
05/24/2024 05:54 AM
No it will just take care if user have account you need also consider status
where users.userkey not in (select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey in ('17','22') and status in (1)))
if you want to consider inflight request enable block inflight request toggle button on endpoint
05/24/2024 08:20 AM
Hi Rushikesh,
Will this not allowed any request while any request is in flight.?
05/24/2024 10:34 AM
Yes using toggle button
05/24/2024 10:12 PM
Hi @asharma , WHERE users.userkey NOT IN ( SELECT a.userkey FROM arstasks a WHERE a.ENDPOINT = '' AND a.status = 1 AND a.SOURCE IN ('REQUEST') UNION SELECT ra.userkey FROM ars_requests ars, REQUEST_ACCESS RA WHERE ars.REQUESTKEY = RA.REQUESTKEY AND ars.status = 1 AND ars.ENDPOINTASCSV = '' ) AND ( ${requestee.id} IN ( SELECT userkey FROM user_accounts WHERE accountkey IN (SELECT accountkey FROM accounts WHERE endpointkey = '') ) OR EXISTS ( SELECT 1 FROM ars_requests ars, REQUEST_ACCESS RA WHERE ars.REQUESTKEY = RA.REQUESTKEY AND ars.status = 3 AND ars.ENDPOINTASCSV = '' AND ra.userkey = ${requestee.id} ) )