We have a reporting services 2008 set up where users are assigned at the Data Source, Dataset
and Report Levels.
If I want to duplicate the permissions of a user from an existing user, then I have to run the following
select C.UserName, D.RoleName, D.Description, E.Path, E.Name
from dbo.PolicyUserRole A
inner join dbo.Policies B on A.PolicyID = B.PolicyID
inner join dbo.Users C on A.UserID = C.UserID
inner join dbo.Roles D on A.RoleID = D.RoleID
inner join dbo.Catalog E on A.PolicyID = E.PolicyID
WHERE UserName LIKE 'ACS\Rebecca'
order by C.UserName ,e.path
But I then have to identify E.Path from the above query and then assign each of these objects to a new user.
Is there a way of copying a current user's assigned permissions to SSRS 2008 objects to a new user with a
T-SQL script, rather than having to do this manually, item by item?