Hello,
I’ve got a case and need help to found solution for it.
There is a MS SQL data source, where we collect information about notification. Data source is built as multi-tenant structure, so in single table we store information from all customers reqistred in the system.
Is simple, tabel structure looks like that
- Id
- Value
- TenantId
Question is if I can configure Grafana, that logged user will see only records: where TenantId = ‘his_tenant_id’ and he / she cannot change this value and this part of where clause will be added automatically to each of queries?
Thanks in advance
Paweł