Hello,
I am Dev just two step ahead of a beginner(recently started to code in Django). I want to develop an application seeking for some thoughts(help/ favors/ etc) from you guys.
The application fundamental is like Hierarchy is like At top soft engg. team (me) > partners> client> location> device> end-user. All are using the same application with some changes.
Database: wanna have a common database for all. all the tables are shared among hierarchy and records are filter according to the roles.
Now the few questions the role-based authentication I can do but is there any other better option or thing available?
The second question is I want some database distribution at partner level there is the concept of schemas (can you put some light on this also). I want this to make queries little fast, independent and secure.
Any type of solution. suggestion, reference you have happy to see
Regards
Dev
Thank you so much.