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.