Show/Hide Toolbars

Reporting Services CMD

Command: SecDiff

 

List items with different security to current folder.

 

SSRS Version:

 

2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), 2012(N), 2012(I), Azure

 

(N)=Native

(I)=Integrated

 

 

Syntax

 

SecDiff [folder][/D][/?]

 

 

 

Parameters

 

[folder]        Folder

[/D]        Detailed Information

[/?]        Displays help

 

Note if the folder is not specified the current folder will be used.

 

Examples

 

In this example we identify items that have different security from the root. Here it shows all items that have different security

 

>secdiff \

 

Security differences from: \

 

DataSource:    \Data Sources\ds1

Folder:        \Report Project1

Report:        \Report2

Report:        \SSRS SQL Azure\test1

Folder:        \test\abc\x

 

 

 

Using the /D option

 

\>secdiff \ /d

 

Security differences from: \

 

==============================================

 Item Type:Folder

==============================================

 

Item: /Report Project1

 

------------------------------------------

User: BUILTIN\Administrators

------------------------------------------

 

 C = Current Security, P = Parent Security

|-|-|-------------------------------------

|C|P| Roles

|-|-|-------------------------------------

|*|*| Content Manager

|*| | My Reports

|-|-|-------------------------------------

 

 

==============================================

 Item Type:Folder

==============================================

 

Item: /test/abc/x

 

------------------------------------------

User: BUILTIN\Administrators

------------------------------------------

 

 C = Current Security, P = Parent Security

|-|-|-------------------------------------

|C|P| Roles

|-|-|-------------------------------------

|*|*| Content Manager

|-|-|-------------------------------------

 

 

 

the item in red above shows the same security for the current and the parent the reason this is reported as a difference in security is due to inheritance being removed.

 

 

Remarks

 

Secdiff without /D identifies where there is a difference in security but not what the difference is.

Secdiff with /D identifies where there is a difference in security. Note it might appear confusion to show the current and the parent item having the same security. The reason this is show is because the inheritance from the parent had been removed.

dir

 

 

 

 

See Also

 

 

 

SecDiff                - Show security differences

SecInherit        - Set item security to inherit

SecSet                - Reset the security of child folder and files to the parent.

 

TreeSec        - Show the security differences for folder

TreeAllSec        - Show security differences for folders and items in the folders.