SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Folder Permissions


Folder Permissions

Author
Message
Bill Mosca
Bill Mosca
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 29
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?
Gift Peddie
Gift Peddie
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8370 Visits: 14456
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
Bill Mosca
Bill Mosca
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 29
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.
becklery
becklery
Old Hand
Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)

Group: General Forum Members
Points: 399 Visits: 187
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

RAQ Report: Web-based Excel-like Java reporting tool
Bill Mosca
Bill Mosca
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 29
Thanks for the syntax. That will be very useful.
Bill Mosca
Bill Mosca
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 Visits: 29
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search