Answers for "sql view all users"

SQL
1

sql server get users

select * from master.sys.server_principals
Posted by: Guest on January-30-2020
0

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
Posted by: Guest on May-12-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language