7

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

0

1 Answer 1

4

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.

2
  • 13
    using this query SELECT * from master.sys.sql_logins I have the following error in azure database: Reference to database and/or server name in 'master.sys.sql_logins' is not supported in this version of SQL Server.
    – sptremblay
    Commented Sep 5, 2016 at 15:05
  • 1
    you can only query master db with that select. you are querying some other db, that's why you get error
    – sensei
    Commented Apr 8, 2018 at 19:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.