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

Hide folders in report manager to users Expand / Collapse
Author
Message
Posted Monday, May 12, 2008 9:04 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 31, 2009 7:53 AM
Points: 150, Visits: 642
Hi All,

I would like to control user access to my Report Manager.In detail,I would like to hide some report folders from certain users when they access the Report Manager.Some of the users are not suppose to see certain folders on the report manager,and some users are suppose to see all report folders.

Example:
User A of Group A can only view/see/access folder A on report manager.User B of Group B can access/view/see both A & B folders on report manager.


How can I do this?.Where should I include this settings?


“I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison
Post #498879
Posted Monday, May 12, 2008 10:52 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 31, 2009 7:53 AM
Points: 150, Visits: 642
No worries I got it figured out.Thanks

“I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison
Post #498970
Posted Monday, May 17, 2010 12:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 10, 2012 12:37 PM
Points: 4, Visits: 25
How did you get this to work for you? I have the same situation and need to know what I need to do to get my users where I want them.

Any help you can give would really be appreciated.

Eric Mann
Post #923088
Posted Tuesday, May 18, 2010 1:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 11:38 AM
Points: 100, Visits: 10,079
You have to go through all folders and manually remove user rights on them (Properties tab -Security)
Post #923845
Posted Thursday, May 20, 2010 7:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 10, 2012 12:37 PM
Points: 4, Visits: 25
Thanks for your reply, I figured that out about an hour after I posted my message. I went back through my documentation and a book I bought then I did some trial and error testing and bingo! It wasn't as hard as I had thought it would be.

Thanks again for taking time to reply.
Post #925628
Posted Tuesday, August 27, 2013 7:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:40 PM
Points: 162, Visits: 53
I see this is an OLD question - but our soluton to this very problem was to use Active Directory group(s) to limit access to reports.

We had a group of reports that only a small group of people should see - so we made the main folder so all our Domain Users could Browse - then on the folder with the reprots that were restricted we made a Active Directory group named ProdRead(could be anmed anything) and gave that group Browse and removed the Domain Users from this folder.

Very simple - just put the people that need access to those resticted reports in the Active Directory group - don't have to do anything special to EACH report as long as they are in the protected folder.
Post #1488744
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse