I want to know the users that are allowed access to a MS SQL Server database. I only want a specific database. Is there a user list hidden somewhere?
What are the ways to go about doing this? Is there an app or through a SQL query?
Use Microsoft SQL Server Management Studio. That is the fastest way to do it. Find the database from the explorer menu on the left-hand side. Expand the folder icon. Go to the Security folder, then click on Users next. That’s it!
If you’re using a different SQL client and you can’t see Security > Users from the GUI. Then your other option is through a SQL query.
This is the query below. More details at this page here: https://www.joseyamut.xyz/2020/08/06/get-user-list-in-a-microsoft-sql-server-database/.
USE <database_name>; SELECT name AS username, type_desc AS type, authentication_type_desc AS auth_type FROM sys.database_principals ORDER BY type;
Happy user hunting! =)