Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Security in SSRS reports.

Posted on 2010-11-28
9
Medium Priority
?
773 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 10

Expert Comment

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

-G
0
 
LVL 10

Accepted Solution

by:
GDG_DBA earned 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

604 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