Post reply

Data Dictionary in SQL

  • 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.

  • 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!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply