Forum Discussion
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...
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
lbendlin Thanks for the reply, I need to create a wrapper on top of the SQL connection which would filter data based on some bussiness need before user's data access.
