Showing results for 
Search instead for 
Did you mean: 
New Member

Report Server: how to edit/delete user rights via relational database

Hi all,


we have the following problem on our report server: it exists a report where different users have only the security role "Browser" on it. No one can change or delete this report, because the rights of the administrators were removed by mistake.


Is it possible to change the RoleID via relational database of the report server?

We saw the table PolicyUserRole and SecData on the database, but we don't know where we should modify it and how it works?


An additional question: How can we avoid such a scenario in the future? Administrators should always have the rights to access and modify a report, even if the rights are deleted.


We hope that someone can help us.


Thank you!

Helpful resources

May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.



Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Kudoed Authors