Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / November 2005

Tip: Looking for answers? Try searching our database.

Security - Browsing Capability

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jerry Spivey - 29 Nov 2005 19:07 GMT
Hi,

I've created two seperate folders under the RS Home page - 1.  Accounting
2.  Human Resources.  I've set the approiate Windows group permissions for
each folder.  When I have someone from HR connect to RS, the user gets the
home page without the Human Resources folder.  Do I need to grant access to
the RS Home page for both Accounting and Human Resources to enable members
of each group to see their respective folders?  I'm assuming if I do users
will be able to see BOTH folders (which is OK as long as ONLY members of the
Accounting group can access the Accounting folder and ONLY members of the
Human Resources group can access the Human Resources folder (this is the way
I have the permissions configured for Browser for each folder).  Is this
assumption correct?

Thanks

Jerry
Jerry Spivey - 29 Nov 2005 19:25 GMT
Got it.  Adding the Windows groups to the RS Home (Security) allows only
respective members of those groups to see the subfolders they have been
granter permission on.

J
> Hi,
>
[quoted text clipped - 13 lines]
>
> Jerry
toolman - 30 Nov 2005 15:23 GMT
Isn't security fun?  I have five divisional groups plus several
departmental groups with any number of sub-groups below those.  All
have separate and overlapping permissions needs.  To compound this our
Active Directory structure is crazy due to staffing and philosophy
changes over the years.  For example, I have an individual who is a
member of over 30 different AD groups none of which are associated with
his current division.  I'm trying to establish new groups just for
SQLRS use that I can maintain but it's slow going, trying to sort
through and assign several hundred individuals into the various groups.
Whew!  Thanks for letting me vent LOL
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.