Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

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.
0
Endelm
Asked:
Endelm
  • 3
  • 3
1 Solution
 
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now