sql show all users

Solutions on MaxInterview for sql show all users by the best coders in the world

showing results for - "sql show all users"
Kelly
05 Jan 2021
1#For the SQL Server Owner, you should be able to use:
2select suser_sname(owner_sid) as 'Owner', state_desc, *
3from sys.databases
4
5#For a list of SQL Users:
6select * from master.sys.server_principals