Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to control report access? Expand / Collapse
Posted Thursday, December 19, 2013 8:51 AM


Group: General Forum Members
Last Login: Tuesday, December 6, 2016 1:15 PM
Points: 131, Visits: 362
Our company does business globally.
They decided a few years ago that
the best way to control user access to SSRS reports
is by creating a "Home Page" report for each group of countries (Europe, Nordics, New Zealansd, etc.)
with the links to the reports that are designed specifically for that region.
Please have a look at the attached
"Wave3 Home Page.jpg" to see what I mean.
"Wave3 Standard View.jpg" shows you what folder structure is behind that Home Page.

I talked to Operations guy and he said "it's not not a good to give users access to Report Manager..?!"
So he is happy with the current setup.

I personally don't like this idea - looking at the reports through another report.
And I'm sure there's gotta be a better way
to control user access on Report Manager.

Any suggestions?


  Post Attachments 
Wave3 Standard View.jpg (8 views, 73.11 KB)
Wave3 Home Page.jpg (8 views, 50.42 KB)
Post #1524644
Posted Friday, December 20, 2013 9:35 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, December 2, 2016 8:37 AM
Points: 646, Visits: 2,324
Is there another layer of security there? What's to stop a user from Germany, clicking on Ireland reports?
Post #1525062
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse