Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2008-09-23 : 10:25:09
|
| We have officially began our migration from 2000 to 2005. One task I've been given is to pull a list of current users/roles and folders within Reporting Svcs they have access to. I'm trying to find the easiest way to do this and I'm thinking from Mgmt Studio console I could run a query to give me such list, or I could connect to the Report Server and look this up too, but I don't see a, per say, "security folder" which would house all this information. There are folders which contain dept-related reports.Is there a standard or generic way to do this, or do I need to look up permissions in every folder?thx,John |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 11:21:20
|
| i think you should be looking into RSExecutionLog db to get these infrormation. |
 |
|
|
|
|
|
Querying for users/roles in SSRS 2005