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

Source: stackoverflow.com

Similar codes

0 vote135 views1 answer
Guid string to binary better
SQL
0 vote163 views1 answer
SQL Server Enterprise
SQL
0 vote125 views1 answer
Mysql update sum same table
SQL
0 vote140 views1 answer
Sqlserver now
SQL
0 vote138 views1 answer
Mysql get date diff in months
SQL
0 vote95 views1 answer
Mariadb list tables
SQL
5 votes137 views1 answer
Oracle nls instance
SQL
7 votes141 views2 answers
N highest salary in sql
SQL
2 votes137 views1 answer
Oracle to_char number format percentage
SQL
19 votes140 views5 answers
Display table in sql
SQL