Controlling access rights through ReportServer DB

[Yazster]

Hi All,

Is is possible to control folder/report access rights directly from the ReportServer table (using SQL Management Studio)?

I have a table with hundreds of user names and need to assign different rights to reports/folders for each user. I will obviously prefer to do this through a SQL query rather than using the supplied reporting services interface.

Any help would be greatly appreciated!
Thanks in advance,
Yazster

 

[bburnell]

This allows you to do it through code. To do it through the database, you'll probably have to execute the stored procedures to come with it. That's where I would start. Sorry I can't help you more. I've never tried it.
~Brett

--------------------------
Web/.net Programmer & DBA
Central PA

 

[bburnell]

Forgot to add the link!

http://msdn.microsoft.com/en-us/library/microsoft.reportingservices.interfaces.acecollection.aspx

--------------------------
Web/.net Programmer & DBA
Central PA