Answers for "sql view all users"

sql server get users

select * from master.sys.server_principals

sql show all users

#For the SQL Server Owner, you should be able to use:
select suser_sname(owner_sid) as 'Owner', state_desc, *
from sys.databases

#For a list of SQL Users:
select * from master.sys.server_principals