Adding Permissions to a Database Role in SQL 05

Last Post 25 Jun 2009 06:54 AM by triley01. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
triley01
New Member
New Member

--
25 Jun 2009 06:54 AM
hello, I have created a Database Role and want to allow this role to have "SELECT" access to all Tables and Views in my DB. From what I am seeing I have to select each table and view in the Securables section, then click the Select Permission in the Explicit Permissions section. There must be a faster way to accomplish this task.

Its being created for users that will access the DB using Crystal Reports.

Any help would be greatly appreciated.
You are not authorized to post a reply.

Acceptable Use Policy