peter_luke_row
8 years agoNew Member
Status:
Needs Votes
Custom Authentication, external database for security, SSRS 2016/2017 regression
I'm reposting my original post from here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f474ba23-7e8d-4c6b-ad41-b2327956226b/sql-2016-reporting-services-custom-security-how-to-access-name-of-item-being-accessed?forum=sqlreportingservices A moderator/curator with the username Boreki indicated that this might be the place to get work prioritised. Couldn't find a reporting services specific forum, nor a SQL Server 2016 specific one so asking this here. In SQL Server 2016 reporting services Microsoft threw us under a bus and broke every ones custom security DLLs, not so bad we just stayed on 2008R2 and 2014, but now customers are asking to upgrade to 2016 and beyond so have to act. The "replacement" does not seem to offer the same facility and I can't tell from the MS documentation what I should use instead. Previously we would use HttpContext.Current.Request.Headers (.Current is now null in 2016 due to the break introduced) to access the SOAPAction to figure out what item is being requested in the IAuthorization.CheckAccess () methods. We used this to then access our applications DB to do further checks on the user because in some cases we need to take different actions based on the type of user in our web application. I was accessing the nodes in the XML obtained from the header indicated above with these selectors: /soap:Envelope/soap:Body/*/rs:ItemPath /soap:Envelope/soap:Body/*/rs:Parent /soap:Envelope/soap:Body/def:LoadReport2/def:Report Effectively what we are doing is bypassing SSRS for all security, none of the items stored in SSRS (reports, data models, data connections) has any permissions set. We control it entirely from our app by looking up an access control list in our apps DB. I cannot for the life of me see how we can access this item information because in CheckAccess () interface method you are passed the security descriptor of the item which does not have information like that path that we are using. Can anyone advise where I can obtain this information in the new SSRS 2016 way of doing custom security?
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v10 hours agoCommunity ChampionNew614Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v18 hours agoCommunity ChampionNew17Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019721 hours agoFrequent VisitorNew6Views0likes0Comments