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 would like to inquire if the solution offered by SacheeTh and lbendlin has resolved your issue. If you have discovered an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

Should you find the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to related queries.

 

Thank you.