Reporting Services - Access control

Hi,

I'm trying to make a report that:

If person x uses the report, it can only access reports that conserns him or her.

How is this possable?

Thank you.

P.S. My idea was to somehow get the windows user of the person using the report, and then use the windows user in your queries to check if the person has access or not.
EndelmAsked:
Who is Participating?
 
rickchildCommented:
You can return the windows user by using the expression:

=User!UserID

But you will still need a lookup set up to check the user groups, either using LDAP for active directory or something like DumpSEC to get local groups.
0
 
EndelmAuthor Commented:
Thanks a lot rickchild!

How can I use this in a query in Reporting Services?
0
 
rickchildCommented:
Are you looking to create one report with links to other reports they are allowed to see, or only show content in a report which the users can see?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
EndelmAuthor Commented:
I've found out how. Thanks a lot! :-)
0
 
rickchildCommented:
OK Great, how did you do it?
0
 
EndelmAuthor Commented:
I used a parameter in a query and gave it the default value = =User!UserID

Then I set the parameter to be hidden (checkbox in the parameter settings).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.