SQL Query for Logins

Is this what you're after?

select * from master.syslogins

On SQL Azure as of 2012;

logins:

SELECT * from master.sys.sql_logins

users:

SELECT * from master.sys.sysusers