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

Folder Permissions Expand / Collapse
Author
Message
Posted Saturday, September 26, 2009 4:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 10:09 AM
Points: 12, 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?
Post #794220
Posted Saturday, September 26, 2009 7:24 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, July 27, 2014 12:14 PM
Points: 3,433, Visits: 14,423
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
Post #794247
Posted Monday, September 28, 2009 1:42 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 10:09 AM
Points: 12, 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.
Post #794729
Posted Friday, October 2, 2009 8:58 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, January 14, 2010 9:09 AM
Points: 141, 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
Post #796981
Posted Saturday, October 3, 2009 12:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 10:09 AM
Points: 12, Visits: 29
Thanks for the syntax. That will be very useful.
Post #797419
Posted Saturday, October 3, 2009 12:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 10:09 AM
Points: 12, 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.
Post #797420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse