Data Dictionary in SQL

• SQLisAwe5oMe

  SSChampion

  Points: 14052

  More actions

  April 11, 2013 at 1:22 pm

  #272936

  Anyone know what's equivalent to data dictionary in SQL server? I think it's the same as DMVs?

  I need to create a login which have read only access to data dictionary in SQL server.

  I think the requestor means, to create a login and map to master db, with db_datareader permission, this will give the person to select from DMVs.

  Any suggestions?

  Thanks,

  SueTons.

  Regards,
  SQLisAwe5oMe.

• Lowell

  SSC Guru

  Points: 323526

  More actions

  April 11, 2013 at 1:28 pm

  #1605762

  datareaders gives them access to data, i think they just want to see the schema(table NAMEs and column NAMEs)

  that permission would be VIEW DEFINITION (in a single database)

  or VIEW ANY DEFINITION to a login to see all databases.

  --in scope of a specific database:

  USE PRODUCTION;

  GRANT VIEW DEFINITION TO databaseusername;

  --or in master

  GRANT VIEW ANY DEFINITION TO loginname;

  the above would let them see every object in INFORMATION_SCHEMA.TABLES

  or in sys.objects

  but they could not SELECT form any table, only see the data structures, and proc/function definitions

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!