April 11, 2013 at 1:22 pm
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
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy