Originally I set up a login user to run SSRS reports.I granted execute rights to some stored procs, etc., and proper table level rights for tables. Everything works well.
Once I started writing more and more reports that need more and more procs and tables, I realized I should grant the login user a certain role so that the procs and tables inherit the correct rights. Then I wouldn't have to keep granting rights at the table level, etc.
Is there a best practice for doing this? I'm fairly new to basic admin, so I'd like to see if this is possible.
I'd be grateful for any advice at all!