I have written story level access Security Rule in place that works as expected. However, the problem is that there are multiple custom sheet level access (App_APPID,App.Object_*) for different Dashboards that overrides the story rule as per audit done. I have taken default "Stream" rule, disabled it, and added story level rule in between.
If I simply remove ",App.Object_*" from all the conflicting sheet level access rules then the Story level access works. However, this obviously impacts all the sheets visibility.
I have also tried App_AppID in story level security rule (Duplicate of default Stream access rule) and not able to restrict these overriding rules.