Solved

Security in SSRS reports.

Posted on 2010-11-28
9
752 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

706 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

22 Experts available now in Live!

Get 1:1 Help Now