Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Reporting Services - Access control

Posted on 2008-06-25
Last Modified: 2008-06-27

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.
Question by:Endelm
  • 3
  • 3
LVL 13

Accepted Solution

rickchild earned 500 total points
ID: 21865692
You can return the windows user by using the expression:


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.

Author Comment

ID: 21872608
Thanks a lot rickchild!

How can I use this in a query in Reporting Services?
LVL 13

Expert Comment

ID: 21874932
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?
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.


Author Comment

ID: 21875676
I've found out how. Thanks a lot! :-)
LVL 13

Expert Comment

ID: 21875756
OK Great, how did you do it?

Author Comment

ID: 21881569
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).

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question