How do I block users from seeing links to reports that they are not authorized to view

I have a group of employees that all need to view different reports. I have some of the teams divided up so that their reports are collected in the same folders. The problem is that one folder may contain 100s of reports and any given user only has access to a few of them. How do I set up Reporting services to let each user only see the reports that they have access to?

i.e. If there are three folders (fld1, fld2, and fld3) and 100 reports in each; and John Dow only has access to rpt1 and rpt 2 in fld1 then when he logs on he should only see the fld1 folder from the home page and once he clicks on that link he will only see links to his two reports inside that folder.

I also have .Net at my disposal. So if I can't achieve this through RS how do I build a work around?
rufassaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
Are you doing this thru a Winform application or a Web application?
0
rufassaAuthor Commented:
I am currently just using the report manager for Reporting Services. But If I were to write a .Net app to create something then it would be web based.
0
Daniel ReynoldsSoftware Applications Developer / IntegratorCommented:
There are various ways to handle user authorization/security.
Here are some:
1) Create roles in SQL and assign the users of the database to a role.
     then Create Secure Views to specific data for each role

2) Create a User table of your own with an associated Role table of your own design and a reports table listing each report.  Create a Role_Report table that will have entries for each role and associated report that that role can view. Create your Web App to Select the viewable reports from the database you created by referencing the Role_Report Table.

As you can see it will take a bit of work if you have a wide variety of roles. It might help if you can limit the number of roles.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.