Starting a New Project somewhat like multitenant saas appication.

[Devender Kumar]

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.

[Scot Hacker]

It's a little tough to understand what your actual questions are, but:

> the role-based authentication I can do but is there any other better option or thing available?

The native Django permissions system is limited to specifying who can see or edit particular models (and even then, is limited to ALL model instances of a given class, rather than specific ones like "just MY posts").  In my experience, there is more to granting permissions for users in different roles than what Django provides. For more complex requirements, I've had great success with django-rules:

https://github.com/dfunckt/django-rules

which you can use in conjunction with Django Groups to make your permissions logic as fine-grained as you need, using arbitrary logic nicely organized into "predicates" that you can combine in and/or statements. And you can use it to keep all of your rules in one central place. 

Keeps permissions logic consistent throughout the project, and nicely testable.

./s