Objective: Create a database level role that has permissions only to a specific "view." And then assign users to that role, so that they can ONLY do selects from that view.
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4042.0 (X64)
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
Via management studio, what are the basic steps, in order, to do the following:
1. Create a database level role
2. Assign "select" permission, for that role, to a specific view
3. Assign a specific user to that role