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
Author Messages
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.

Acceptable Use Policy