Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Hide folders in Report Mng

Author  Topic 

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-05-12 : 11:02:26
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.

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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-12 : 11:17:59
http://www.mssqltips.com/tip.asp?tip=1357
Go to Top of Page

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-05-12 : 11:39:22
Thanks Visakh,
I did give it a try,But what it does is hides the report in the list[which can be done in report mng]itself .

I need a way to somehow control each individual user view to the report folders.For 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.

Any suggestions?
Go to Top of Page

jhermiz

3564 Posts

Posted - 2008-05-12 : 11:42:05
quote:
Originally posted by LOOKUP_BI

Thanks Visakh,
I did give it a try,But what it does is hides the report in the list[which can be done in report mng]itself .

I need a way to somehow control each individual user view to the report folders.For 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.

Any suggestions?



Just change the security of the report(s) ?


Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

LOOKUP_BI
Constraint Violating Yak Guru

295 Posts

Posted - 2008-05-12 : 13:33:15
I got it figured out by adding users to a certain Group and then changing the security option on individual folders on the report mng.

Thank You All.
Go to Top of Page
   

- Advertisement -