CODEWITHSUNDEEP
sqlsql-server
ehmBEE
ehmBEE

Reputation: 239

Retrieving users for specific SQL Server databases

I have a few SQL Server databases (all in one server), containing their own set of users. Now I'm trying to design a small application that would query those users and then display them in a report (TBD). I've looked over online how to do this, however I didn't find any. Is it possible in SQL Server to retrieve all the users of a database? If so, how?

Upvotes: 2

Views: 2039

Answers (1)

marc_s
marc_s

Reputation: 754258

On SQL Server 2005 and up:

  • connect to that specific database you're interested in 

    USE Databasename

  • execute this query

    SELECT * FROM sys.database_principals

That gives you a slew of information on all users defined in the database

See the MSDN documentation for a detailed explanation of all rows returned from that view.

Upvotes: 2

Related Questions