September 26, 2009 at 4:30 pm
I added a usaer as a content manager using windows authentication, but he still can't see teh sub folders. All he sees is the Header on the default Reports page. I had to temorarily give him admin rights on the server, but as you know this is not a good work-around.
What am I missing in the settings for this user?
September 26, 2009 at 7:24 pm
There are two things you could try ask the person to add Report manager url in Lan Settings in connection in IE or trusted sites. If that did not work they may have to disable protected mode Vista and Windows 7 don't like it.
Kind regards,
Gift Peddie
September 28, 2009 at 1:42 pm
Thank you for taking the time to respond. I'll have the user check to see if the server is in the trusted security group. His machine is on the network just like mine and should have the same group policies, but you never know.
October 2, 2009 at 8:58 am
To see a list of the top-level folders and associated user permissions, run the following:
select
name,
path,
username
from
catalog
join policies on
catalog.policyid = policies.policyid
join policyuserrole on
policyuserrole.policyid = policies.policyid
join users on
policyuserrole.userid = users.userid
where
parentID = (select itemid from catalog where parentid is null)
order by
path,
username
Or, you may refer to the url below:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1271344,00.html
October 3, 2009 at 12:00 pm
Thanks for the syntax. That will be very useful.
October 3, 2009 at 12:01 pm
I think it's all figured out. I hadn't given the user browser rights to the root folder. Once that was done it all worked.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply