Access Query in Endpoint and users visibility

[ant]

We have a requirement where  endpoints should not be shown to users who do not have an account in the endpoint.

Is there anyway to achieve this using endpoint access query?

If access query alone is not sufficient, would very much appreciate a suggestions

[RakeshMG · Accepted solution]

Please use Access query in Endpoint config.

Refer to following document for more details : https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter04-Onboarding-and-Managing-A...

[dgandhi]

Yes you can use access query to achieve this use case. Below sample for your example:

where users.userkey in (select userkey from user_accounts where accountkey in (select accountkey from accounts where endpointkey = 73)

endpointkey should be based on your requirement.

Hope this helps!!

Just another thought, how the user will request the account in your use case, will it be part of recon only (since you are restricting from users to request)

Thanks