User administration

[isedwards]

pyopencdms currently has SQLAlchemy models (see v4_1_1_core.py) for 25 core tables originally listed in the pdf here (also documented in this issue.

It looks like the list of core tables was incomplete. We also need at least the climsoftusers table and possibly others.

• Is it easy to add additional models?
  • If yes - we should add just climsoftusers for now
  • If adding to the model is a difficult process then we should investigate whether other tables should also be added.

Climsoft roles and user management is documented in the pdf here.

• How should we implement user management (adding, removing and updating users) for Climsoft given than authentication is handled by opencdms-api?
• What is the best approach to restricting access based on a user's Climsoft role? Would we need to implement middleware in opencdms-api or in climsoft-api?