I have granted an Azure user within our organization with SQL Contributor access to our SQL database:
But when the user attempts access the database from Azure's Query editor, they get the message
Login failed for user
Can someone let me know if there are any additional permissions that I need to grant the user?
Azure SQL has its own users, roles, and permissions inside it. Assigning a role from Azure Portal with Azure's RBAC won't give the user rights to connect to the database.
You must instead connect to the database with an Entra ID (Azure AD) user and run e.g.:
CREATE USER [test.user@example.com] FROM EXTERNAL PROVIDER;
EXEC sp_addrolemember 'db_datareader','test.user@example.com';
This would create the user and grant them read access to everything. You should consider what access they need.
If the user only needs to connect and run queries, you don't need the Azure RBAC role.