Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sreenu9f
Yak Posting Veteran
73 Posts |
 Posted - 2013-05-15 : 10:26:30
|
| I have built a report model which is accessed by different user groups which is listed in the security properties who build reports from models and store them on the reporting server.My question is i want to restrict the user groups by an entity in the model ( field called facility). how to do this in msdn they have provided the solution for this using share point but we dont use share point. please suggest..thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-16 : 00:30:05
|
| you mean custom security model on your report model based on field value?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
sreenu9f
Yak Posting Veteran
73 Posts |
Posted - 2013-05-16 : 07:56:57
|
| correct visakh.i have a field in a report model called facility which holds 4 distinct values only but will be populated for every row in the model. so i would like to restrict the users based on the value in that field.please suggest.thanks, |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-16 : 08:06:39
|
| http://blog.dragonsoft.us/2011/10/14/installing-custom-security-extensions-for-ssrs/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssrs report model security