Forum Discussion
CredentialMissing for SQL kind inside Custom Connector
That's what RLS is for?
If ms_query ,
If you want to limit some access based on each user, you can use RLS and OLS for this as lbendlin suggested.
Initally connect using the standard connection using the SQL user name password. Then setup the Ro level Security and share with users accordingly.
You even can use the Object level Security filtering some part of the tables with specific user group.
If you have a larger yser list, you may bring the same users to the model and setup a dynamic RLS where each user filers the specific rows accordingly
Community SupportHi ms_query,
We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.
If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.
Thank you.