HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How do you list all logins for Sql Azure?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
youallsqlloginsazureforhowlist

Problem

What queries can I use to list all logins for a server and database in SQL Azure?

I tried running select * from sys.sysusers but I'm guessing that's just showing the users

Solution

A login is for authenticating to the server.

A login maps to a database user to access the database.

SELECT * from master.sys.sql_logins will list logins for Azure.

Context

StackExchange Database Administrators Q#140980, answer score: 4

Revisions (0)

No revisions yet.