Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #sql #show #users
ADD COMMENT
Topic
Name
6+5 =