SQLTeam.com | Weblogs | Forums

Cloning a user?


#1

Hello all,

I'm fairly new to the world of SSRS so please forgive me if this is a stupid question.

Someone at work is on holiday next week and has asked me if I can give someone access to our Report Server and "have exactly the same access as me" in order to cover off her work.

How do I go about finding out exactly what reports the user can see?

Thanks for any guidance.


#2
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
order by C.UserName   

http://www.lmgtfy.com/ :slight_smile: