Hi, I'm trying to pre-filter database before query is made by SDN/RX. Is is possible to do so with something like cypher query for filtering out data and leaving sub-graph before real request comes in?
It's not Role based system, each user is specific and can have multiple ways and nodes that are connected and allowed to him but also their children could be denied. So if I could simply create something like sub-graph and let SDN RX apply query on it, it would be amazing.
Guessing that probable answer is no, is there an alternative for such apporach. Let's say I have an (:Level)-[:HAS]->(:OtherLabel)-[:HAS]->(t:ThirdLabel)->(deep node :DeepLabel). And I have (user1)-[HAS_ACCESS]->(other noed:OtherLabel). I need to be able to filter out graph so that any kind of query that comes in doesn't see the (t:ThirdLabel) and (deep node :DeepLabel) BUT they could have access to (some other deep node :DeepLabel) not connected to (other node) . Reason is that some queries might try to execute MATCH (:ThirdLabel) ... OR MATCH (:OtherLabel).. and given that user can have some nodes of specific type accessible and others not query would execute and I would have to post filter every single query I make or I would have to customise every query I have so far.
To repeat system has no roles for this and there's no solution that helps which includes having roles. It's user specific security. Example if there's 1000 buildings in the system and we want to give access to users to some of them - we probably want custom access for each user and roles don't help except for admin. Now if users can have forbidden access to certain rooms it gets even more complicated.
I can easily do query for it but don't know is it possible to downsize graph before doing actual queries.