Answers for "get all users in sql database"

SQL
3

sql show all users

#show all users and hosts
SELECT User, Host FROM mysql.user;

# show all users with passwords
SELECT User, Host, Password, password_expired FROM mysql.user;
Posted by: Guest on October-19-2021
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