Forum Discussion
Azure SQL server get all users and their roles
Hello, what are the commands to get a list of all users that have access to an Azure SQL Server? We are using AAD - Universal with MFA to login. I have tried several different ways using Master ...
I found a link that explains that with Azure SQL we can only get Database level and not the Server level unless we build a VM.
So I found my access, but I need all User access for an Audit.
Here is a reference.
https://dba.stackexchange.com/questions/188266/how-to-detect-the-server-admin-user-on-azure-sql-server
So I found my access, but I need all User access for an Audit.
Here is a reference.
https://dba.stackexchange.com/questions/188266/how-to-detect-the-server-admin-user-on-azure-sql-server
How do we get the users list in each database levels and their last logins details.?
Thanks