Hi fellow thwackers,
Hoping someone out there can shed a positive light on a solution we're trying to develop. Does anyone have any experience or guidance we could leverage to achieve a different way of displaying data and content for our users without the need to create a range of almost duplicate but specific views (we already suffer from severe views and custom props bloat as it is).
Ultimately I want to build a single view with multiple custom resources that will all be built using custom SQL script to define the datasource. To make a single view work (and therefore reduce the management & maintenance by us as tools owners), I want the SQL script to be able to read and reference the current user account logged in and the limitations we’ve applied to it to appropriately filter the content in the resource (table, graph etc).
The internal application of this would be to allow specific personnel working under various teams to use this same view but the limitations applied are referenced from their account directly in the datasource script.
e.g. Service Desk accounts limited to devices tagged with a Custom Prop set to Level 1 or a specific customer name
Networks Level 2 accounts limited to devices tagged as Level 2 with different resources filtering device types
Can the current user be referenced and the limitation applied to that account used within the SQL script?
We’ve found with some testing that when referencing the user account, it is reading the data set with dbo privileges and is therefore ignoring the limitation that we are trying to apply.
Further and ultimate application for this solution would be to move this in the direction of custom tables in the Orion DB and apply limitations to the other data stored in those – I appreciate that this is officially SW “unsupported” territory so don’t expect a hard & fast solution, but any guidance or help would be greatly appreciated.
Failing that – is there any way to enable SWQL version of the same script to reference a custom table that’s been added to the db?
Thanks for reading.
