I have a group of analysts who currently have been assigned the role "datareader" to a database in SQL Server. These analysts need to view the "details" behind a "view". Currently, they can only execute the view and see the results. Does anyone know how to give a group or assign permissions to allow the details of view? If you right click on a view and select "create as" will allow show the details but allows the user to "create" or alter a new or existing view.
Any help would be appreciated.