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?
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud


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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL - sum months, quarter, YTD 9 91
SQL Server agent & maintenance task issue ? 8 65
How to run sql statements from SQLCMD or command line 2 55
Incremental load example 2 52
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 …
Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

864 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now