Prev: Label printing
Next: Localization problem
From: Thom on 1 Mar 2010 17:54
I have inherited a SSRS 2005 installation that has access akin to spaghetti.
I would like to export the current security setup, folders, users, roles so
that we can start to clean it up.

Is there a built in way to do this, or has someone already created a script
to do this?

It would be much appreciated.
From: Thom on 3 Mar 2010 18:06
I found a snippet online and filled it out a little bit and now I have this:

SELECT Path,UserName, RoleName FROM dbo.PolicyUserRole
JOIN dbo.Users ON dbo.PolicyUserRole.UserID = dbo.Users.UserID
JOIN dbo.Roles ON dbo.PolicyUserRole.RoleID = dbo.Roles.RoleID
JOIN dbo.Catalog ON dbo.Catalog.PolicyID = dbo.PolicyUserRole.PolicyID
WHERE PolicyRoot = 1
AND Type = 1
AND path NOT LIKE '/Users Folders%'
ORDER BY path

Lots of Data but I can work with it.


"Thom" wrote:

> I have inherited a SSRS 2005 installation that has access akin to spaghetti.
> I would like to export the current security setup, folders, users, roles so
> that we can start to clean it up.
>
> Is there a built in way to do this, or has someone already created a script
> to do this?
>
> It would be much appreciated.
 | 
Pages: 1
Prev: Label printing
Next: Localization problem