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 vote195 views1 answer
Pl sql search in all packages
SQL
2 votes214 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
12 votes196 views1 answer
How to change the value of a table in sql
SQL
0 vote208 views1 answer
Flexible search query delete table
SQL
3 votes195 views1 answer
How to remove characters from string in mysql
SQL
4 votes205 views2 answers
Tsql utf to local time
SQL
2 votes216 views1 answer
Oracle convert run_duration to number
SQL
0 vote201 views1 answer
Fill up postgres db
SQL
2 votes206 views1 answer
Wait delay in sql server
SQL
1 vote233 views1 answer
Sql how to replace full stop
SQL