how do you set persmissions on the database dictionary
asked Oct 08 '10 at 04:00 AM in Default
Making a huge assumption...You want to grant permission for people to look at the meta data within a server or a database. You can grant this through VIEW SERVER STATE for the server or VIEW DATABASE STATE for individual databases. This will expose the system views and dynamic management objects.
answered Oct 08 '10 at 05:10 AM
Grant Fritchey ♦♦