3

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

1

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.

  • 10
    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 Sep 5 '16 at 15:05
  • you can only query master db with that select. you are querying some other db, that's why you get error – Amel Salibasic Apr 8 '18 at 19:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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