How to get the list of all database users

January 25, 2023 by Tarik

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

Ref.
SQL Server Tip: How to find the owner of a database through T-SQL

How do you test for the existence of a user in SQL Server?