January 11, 2016 at 12:46 pm
To give access to SSRS url, instead of using the url (property or security settings), is there any option to use Queries to achieve the same thing (or) is the url way the only method?
January 11, 2016 at 3:12 pm
The underlying structure of users, policies and roles is pretty complicated and everything is referenced via GUIDs. I've never really changed it by SQL and that's not supported by MS anyway. You might have some luck looking at doing it with rs.exe scripting but I've always just done it via report manager. The best way to manage it in my opinion is using AD Groups and the report manager.
If you really want to understand the underlying structure these guys did a nice 5 part blog post on it:
http://sornanara.blogspot.co.uk/2011/05/ssrs-reportserver-database-tables.html
http://sornanara.blogspot.co.uk/2011/07/ssrs-reportserver-database-tables.html
http://sornanara.blogspot.co.uk/2011/07/ssrs-reportserver-database-tables_10.html <-----Users and Policies
http://sornanara.blogspot.co.uk/2011/07/ssrs-reportserver-database-tables_5274.html
http://sornanara.blogspot.co.uk/2011/07/ssrs-reportserver-database-tables_5274.html
It doesn't tell you how to do what you are asking, but it is very useful for understanding the ReportServer database schema.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply