Implementing Data Security in a Report Model

Article: Implementing Data Security in a Report Model

Bob's SQL Reporting Services Blog — Sat, 18 Mar 2006 21:08:01 GMT

I just posted&nbsp;the first&nbsp;article on my blog. Here's the abstract:
The report models introduced...

Implementing Data Security in a Report Model

Prologika — Sun, 19 Mar 2006 02:54:19 GMT

Bob Meyers (the mastermind behind the RS 2005 Report Builder) tells us how to implement horizontal data...

Good post on Model Security

Russell Christopher's Semi-Useful BI Musings — Mon, 20 Mar 2006 16:38:11 GMT

Bob Meyers posted a really good write-up on various ways to secure your report model!
http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.asp...

re: Implementing Data Security in a Report Model

bell.joshua — Tue, 25 Apr 2006 20:21:50 GMT

FYI... The URL listed in one of the prior responses does not work for me. (http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.asp)

My question:
Is it possible to use Active Directory groups (or Organizational Units) to assign security filters? The original post outlines the method for retrieving the current user ID, but is there a way to determine whether or not the current user is in a particular group?

If not, I think this would be a good enhancement to include in the next Report Builder release.

re: Implementing Data Security in a Report Model

bell.joshua — Tue, 25 Apr 2006 21:10:21 GMT

Well... disregard the URL comment in my previous post. The URL was truncated in the preview (ends in .asp instead of .aspx), and when I added the 'x', I realized that it was the URL for this page anyway.

/sigh

re: Implementing Data Security in a Report Model

Krip — Mon, 25 Feb 2008 21:36:07 GMT

Having some trouble getting Security Filters to work. I've added a filter to an entity and deployed the Report Model, but still see all data when running a report. Is there some other setting I'm missing?

Thanks,

Krip

Implementing Data Security in a Report Model Using Folder Namespace

boumerlin — Sat, 07 Mar 2009 01:51:58 GMT

I have some questions regarding report model security and folder namespaces. Perhaps you can help me out? Shouldn't I be able to prevent a user from viewing/accessing a model based on folder security settings on the report server? I'm having difficulty implementing this so that User_1 can only view the model for Client_A and User_2 the model for Client_B. Client_A and Client_B each have their own folder structure.

I'm using Forms Authentication and right now, once a user is Authenticated, the user has carte blanche to the report models with the ability to see the models and access them.