Share
ReportHi
Is there any security risk in enabling TDS Endpoint for Reporting using Power BI ?
How can we restrict access to sql DB using SSMS once TDS endpoint is enabled ?
Thanks
You’re offline. This is a read only version of the page.
5
Hi
Is there any security risk in enabling TDS Endpoint for Reporting using Power BI ?
How can we restrict access to sql DB using SSMS once TDS endpoint is enabled ?
Thanks Richard .
Hi The Dataverse TDS endpoint is a read-only emulation of the SQL protocol over the Dataverse business layer. It is NOT a direct connection to the underlying SQL server. The Dataverse security model is implemented in the business layer and applied to the TDS endpoint just like it is through the web API's.
You can't control what clients specifically connect to the TDS endpoint. However, any users will only get records that they could access through the UI or odata web api already.
Hope this helps,
Rich Dickinson
PM Dataverse
How do assign Role to user at Azure SQL DB level ?
Hi,
It only gives you Read access on tables.
You can not perform insert/delete query.
You can control security by assigning the appropriate security role to an User who will access the data via sql
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (