Is it possible to setup an user with his AD account and use the same account for accessing the Datasource ? for example MySQL ?
I see this page https://docs.dremio.com/security/sharing-and-permissions.html ; but, could not find more information.
I would love to have the user impersonation on Dremio such that the user queries are passed on to the underlying database as himself rather as a dremio user. So that the user will be able to access the DB only with his access privileges.
Reason for the ask:- Else it becomes a problem to manage the user queries and be responsible for being in the middle.