![[Webinar Show Notes] User-Based Data Access in Bold BI Dashboards](https://www.boldbi.com/resources/wp-content/uploads/2020/07/user-based-data-access-featured-v1.webp)
This blog provides show notes for our July 23, 2020, webinar, “User-Based Data Access in Bold BI® Dashboards.” The webinar is presented and hosted by Syncfusion® developer Pravin Joshua D.
Introduction
To start off with, here is what you can do with Bold BI and user-based data access:
- Restrict data based on logged-in users. For example, you can create a dashboard that can be shared with multiple users, with each viewer accessing only the data they have permission to see.
- Reduce deployment time. Since you don’t have to create individual dashboards for each user, you save a lot of time.
- Assure fine-grained security. Row-level security helps to filter data for users and groups.
- Switch connections based on logged-in user for SQL Server connections. Useful when using separate databases.
Row-level security
Now let’s go into more detail about what we’re offering with one of these, row-level security:
- Filter data at the row level based on the user.
- Map users and column values directly using name or email identities.
- Auto-map from a permission table.
- Auto-map from a custom query.
- Impersonate users when designing the dashboard.
Dynamic connection string
When you have your data in different databases, or a different server for clients, it can be tough creating a dashboard for individual users. In Bold BI, you have the option to switch connection strings based on logged-in users:
- Use in both embedding and direct-use cases.
- Reuse the same dashboard for different users or clients.
Try out all the features of Bold BI with 30-day free trial.Start Embedding Powerful Analytics
Conclusion
We have taken a look at how you can create dashboards that can be used for multiple users and clients, avoiding the need for individual dashboards based on access. We hope you enjoyed this webinar and found a new way of optimizing dashboard creation and deployment time.
Get started with Bold BI® by signing up for a free trial and create more interactive business intelligence dashboards. If you have any questions on this blog, please feel free to post them in the following comment section. You can also contact us by submitting your questions through the Bold BI website or, if you already have an account, you can log in to submit your support question.
