Checking Level Of Security Given The Folder Structure Being Used

Jan 23, 2008

Hi,

Could someone please advise if the report folder structure I am proposing will be secure enough so unauthorised users can't access the reports?

I have created three folders; Departments (that contains subfolders being one for each department), Sections (that contains subfolders being one for each section), and Open Access. A manager will either see the Department or Section folder and then the relevant subfolder for the area he/she manages.

I have deployed the reports from the Development Studio to the Home page, made them invisible there, but created linked reports that then show in the subfolders. Each subfolder contains a separate linked report and each has parameters set within the Properties tab of SSRS that only enables the manager who will access that subfolder to see the report details specific to their area.

A manager will then be given the browser role for only the subfolder he/she has access to.

I would like to be sure that a manager will not be able to see information in other subfolders. Will my proposed structure be secure enough?

Thanks

View 5 Replies

Inheritance Of Security Role In Folder Structure Of Reports

May 16, 2007

Hi,
I have a folder structure of reports like this
Home
|
/
A B

Now, suppose I have created this folder, A first and user, say A_User is given permission to view this folder. I am expecting this user to browse from 'Home' to A folder but as you know to browse folder 'Home' he must also be added to 'Home' folder . So I add him to 'Home' now.

The problem comes when I add new folder B, for user B_User. The moment I add this folder A_User is also added to folder B because of the inheritance of users to child folders.
So user A is able to see both A and B folder....and thats my problem, he is supposed to only A folder and not B

Is there any way to disable this inheritance feature ??
I tried deleting A_User from B with a script using "InheritParentSecurity" method of ReportingService but it says that it can not delete inherited users.

How can I fix the problem ? without need to manually delete users from folders ??/

thanks

prashant

View 3 Replies View Related

Can't See Any Folder Structure In The Report Server ?

Jan 30, 2007

Hi i have my customer security method using the

http://msdn2.microsoft.com/en-gb/library/ms160724.aspx msdn article !

now my problem is i can login using different different users login

but i can view the deployed folder sturcutre using one user account only,others just have the accees to the connect to the report server only ?

but in my rsreportserver.config file

i already added three seperate user account like this

<adminconfiguration>

<username>asd></username>

<username>asd1></username>

<username>asd>2</username>

<adminconfiguration>

and i have added these user name on to the report report server users table as wel,

but problem is again i can see folder structure using asd2 user login only,other users just have the login permision ony,they cant see the folder structure ?

what is the problem with this ?

regards

sujith !

View 4 Replies View Related

Checking Columns Level Dependencies

Nov 4, 2004

Hi all,
Need a big favour, I have to collect information like
TableName-> it's all columnNames--> dependent table name of EachColumn(where this column is refrenced)

I have managed to get some info like:-

select so.name as 'Table Name',sc.name as 'Column Name',st.[name], sc.length,sc.isnullable,so.crdate
from syscolumns sc
inner join sysobjects so on so.id=sc.id
inner join systypes st on st.xtype= sc.xtype
where so.xtype='U'
order by so.name

sp_depends and sp_MSdependencies is not returning me same fields..