Data View Web part gives error when not users don't have access to all sources

grpfinance
grpfinance used Ask the Experts™
on
Hello there
I am trying to create a calendar in Sharepoint which displays all calendar items from few sites in one collection and  managed to display them using DataView Web Part. The problem is that when people don't have access permission to all of the source sites they get the web part displayed with the following text "Access denied. You do not have permission to perform this action or access this resource". What I would like them to see instead, is only the calendar items to the sites which  they have access to. Am I using the right web part - i've tried content query too, but no success.
Any help will be appreciated. Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2009
Commented:
Yes they need to have atleast "Read" level access to the sites from where you are pulling the calendar information. You can create a security group that includes all users (assuming this is for all users) and then make this group have read-level access to the sites. You can update the permissions on the document libraries, lists, etc on the respective sites so that this group does not have access (except the calendar ofcourse).

Author

Commented:
I understand the permissions although the problem is that I want only two users to be able to see the calendar items from two sites and the rest of them to see only the one site calendar items. Even if I give the two users permissions to both sites, the web part will still give error to the rest of the users.

I need it to work similar to the navigation - if you have access to a site you can see it, if you don;t have access you can't see the site in your navigation, i.e Everyone can see the calendar items to the sites which they have access to.

Author

Commented:
Any update or help on this will be appreciated. Thanks
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Top Expert 2009

Commented:
sorry, been travelling, let me get back to you regarding this.

Author

Commented:
66866 any update?
Top Expert 2009

Commented:
hi grpfinance,
as long as you are bringing data from different sources to the same dataview webpart, it will show the access denied message if the two lists have different permissions. the reason being, the dataview webpart is more of a client based webpart. The data is initially rendered and then the permissions are applied. The problem is if the list itself is not accessible, the DVWP throws an error which comes as what you are experiencing.

Author

Commented:
Any other ways of achieveing this?
Top Expert 2009

Commented:
Instead of modifying the permissions at the list level, what happens if you keep the permission uniform at the list level however modify the permissions at the item level. Have you tried that?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial