question

ak1516 avatar image
ak1516 asked

Report model security configuration issues

We have a requrement to design a report model that is unique to each state users. report models created and deployed to report server. and now when users log into report server they only see the report model and data source for their state and they have only report builder access, no site setting,no any other setting.This is done by role assignment and item level security,no problem. The problem is when a user runs the report builder he/she sees all the report models on the right side window of the report Builder,rather we want the specific model to show up.Please shed some light on this thanks
ssrsreportmodel
8 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
I can't answer this but I know some folks who can. Let me send out some emails.
0 Likes 0 ·
ak1516 avatar image ak1516 commented ·
i possible .. Please...
0 Likes 0 ·
Tim avatar image Tim commented ·
Just put it out on twitter as well for the world to see. Someone should be able to lend a hand shortly. I am curious about this too as I have just entered into the SSRS world myself. I published my first production reports this week.
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
On twitter use the #sqlhelp tag...
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
I thought that you can add security at the model level, via the web front end... Using AD groups you should be able to filter them out. Are you using 2005 or 2008?
0 Likes 0 ·
Show more comments
Tim avatar image
Tim answered
I got this response on twitter. [MSDN Article on Security Models]( http://msdn.microsoft.com/en-us/library/ms156505.aspx)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MarkVSQL avatar image
MarkVSQL answered
You can configure security indepentently for each model from Report Manager. So, you would go to each model in the Report Manager interface and configure a group to have access to that model. Then you could manage the security by modify Windows group membership (my recommendation, rather than granting acces for each user's individual account). The following two options would require making changes to the model but allow you to have onle one model: You could have each State be its own entity within the model. Then, in Report Manager, you could configure Model Item Security and grant appropriate Windows groups access to each State as appropriate. Another option that would allow for a single report model for everyone would be to set up row-level security within the report model. It takes some effort to set up, but it would then filter the rows returned to each user based upon their access level you have chosen for the State values. This can be a little complex during setup but allows for far less admin down the road since you would only have one report model to administer. I hope this helps you.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ak1516 avatar image ak1516 commented ·
We are using custom authentication. Even after configuring the model item security the user is able to access the model from the report builder.... :(
0 Likes 0 ·
ak1516 avatar image ak1516 commented ·
The only help needed is in restricting the report model access to the users through report builder .....
0 Likes 0 ·
ak1516 avatar image
ak1516 answered
Can any one please help me... in figuring this out ?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.