Security in SSRS reports.

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.
n_srikanth4Asked:
Who is Participating?
 
G GodwinDatabase AdministratorCommented:
Take a look at this tutorial from Microsoft.

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

-G
0
 
joeviCommented:
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
 
G GodwinDatabase AdministratorCommented:
What are you wanting to do?
-G
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
n_srikanth4Author Commented:
Hi ,

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

Regards,

Sreekanth.
0
 
G GodwinDatabase AdministratorCommented:
What are you wanting from your row level security?

-G
0
 
joeviCommented:
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
 
joeviCommented:
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
 
n_srikanth4Author Commented:
excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.