Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Help

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-04-24 : 09:31:15
I would like to expose the views with read only access and nothing else. What is the best way to accomplish this?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-24 : 10:18:10
Create a role, grant select on all views to that role. Assign users to role.
Go to Top of Page
   

- Advertisement -