Adding AAD external user to ADX database

Question

I'm trying to give an AAD guest user permissions to access a database within an ADX free cluster

This query executes correctly, but he is not able to access the DB

.add database ['Test-db'] users ('aaduser=name.surname@acme.com') 'PoC user (AAD)';

I've tried also with the tenant id

.add database ['Test-db'] users ('aaduser=name.surname@acme.com';87101f8d-xxxx-xxxx-xxxx-xxxxxxxx') 'PoC user (AAD)';

and received this error:

Can anyone help me in solving the issue?

Thanks,

Elisa

Answer 1

Hello @Elisa Piccin ,

have you tried to add the user by hand in the Azure Portal?

Go to the Permissions pane of your database:

That user must be available in your AAD to be found.

---

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

Answer 2

@Sander van de Velde I was able to do it using the user AAD id, something like:

.add database ['database-name'] users ('aaduser=b40a91df-xxx-xxx-xxxx-xxxxxxxx;companyname.onmicrosoft.com') 'PoC user (AAD)'