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: Friday, March 21, 2014 4:05 AM
Points: 79, Visits: 188
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, April 17, 2014 12:30 PM
Points: 572, Visits: 2,070
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