Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 29, 2014 1:35 PM
Points: 83, Visits: 201
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?

Thanks,
Rob


  Post Attachments 
Wave3 Standard View.jpg (7 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: Tuesday, December 16, 2014 1:11 PM
Points: 612, Visits: 2,145
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