Solved

Security in SSRS reports.

Posted on 2010-11-28
9
759 Views
Last Modified: 2012-05-10
Hi Experts,

       I want to implement  Row Level Security  in my  SSRS reports..  Please walk me through the best practices and approaches of  how to achieve them.

Regards,

Sreekanth.
0
Comment
Question by:n_srikanth4
  • 3
  • 3
  • 2
9 Comments
 
LVL 4

Expert Comment

by:joevi
ID: 34227569
I'm afraid your only option is to roll-your-own using userid and filters in the report itself or via stored procedure variables.
0
 
LVL 10

Expert Comment

by:GDG_DBA
ID: 34234600
What are you wanting to do?
-G
0
 

Author Comment

by:n_srikanth4
ID: 34238438
Hi ,

Can you give me an example or an approach , the best practices of how to achieve them.

Regards,

Sreekanth.
0
 
LVL 10

Expert Comment

by:GDG_DBA
ID: 34239033
What are you wanting from your row level security?

-G
0
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

 
LVL 10

Accepted Solution

by:
GDG_DBA earned 500 total points
ID: 34239354
Take a look at this tutorial from Microsoft.

http://technet.microsoft.com/en-us/library/ms365305.aspx

-G
0
 
LVL 4

Expert Comment

by:joevi
ID: 34326608
GDG_DBA: If your comment didn't help Sreekanth, the Report Model+Report Manager solution for row level security was a 'hmmmm' for me. ;-) Good work

n_srikanth4: Give the man some points.

0
 
LVL 4

Expert Comment

by:joevi
ID: 34505597
GDG_DBA provided a good starting point for 'best practices and approaches' in delivering SSRS row level security. Short of writing the report, I'm not sure what else n_srikanth4 expects.

0
 

Author Closing Comment

by:n_srikanth4
ID: 34676813
excellent
0

Featured Post

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

Question has a verified solution.

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
A short film showing how OnPage and Connectwise integration works.

930 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

10 Experts available now in Live!

Get 1:1 Help Now