Forum Discussion

ms_query's avatar
ms_query
Frequent Visitor
1 year ago
Solved

CredentialMissing for SQL kind inside Custom Connector

I was trying to create a custom data source which is wrapper on top of SQL.   I have set the Username-Password credentials for the custom data source. But it reports an error of missing crede...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    That's what RLS is for?

  • SacheeTh's avatar
    SacheeTh
    1 year ago

    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 

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi ms_query,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

 

Thank you.