Read only user for security users in a database

• chugghin

  Say Hey Kid

  Points: 672

  More actions

  August 4, 2014 at 12:19 pm

  #397155

  I'm not new to SQL, but there are some things I've never done. Creating a read-only user who can see all of the users in a database is one of them. Is this possible?

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  August 4, 2014 at 12:50 pm

  #1734925

  Add the user to db_datareader, and grant the user VIEW DEFINITION on database level:

  GRANT VIEW DEFINITION TO nisse

  Note that this gives the user right to see any definition in the database, that is stored procedures, tables, certificates etc. And users.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]