Background/Constraints:
- My business is very comfortable with the use of "modern" SQL databases, accessed via networked software solutions
- My business will not allow "direct" database entry/manipulation via ad hoc methods, including queries, except by a very small pool of dedicated database admins
- My business has solutions for general controlled read-only/reporting access of SQL databases
- My business is in the medical device manufacturing industry, so we have particular needs around "21 CFR Part 11", but these are common concerns like individual assignment of accounts/passwords, audit trails, etc.
- I envision multiple different databases for different business issues; not all authorized users will have access to (have accounts in) all database. (i.e. there won't be "one big database").
- design SQL databases, or otherwise accept/interface with SQL databases that may have been designed by others
- design interfaces (preferably via a webapp, using a modern browser) that allow for data entry into a SQL database by authorized users (with unique name/passwords) and will inherently generate audit trails (even if I have to design audit trails into an individual database itself, although I'd prefer a more inherent solution) for individual SQL databases
- allows for management of the authorized users (even if I have to design user management into an individual database, although I'd prefer a more inherent solution) of those individual SQL databases
- be a commercial solution, but one that doesn't require individual licenses for users to make use of developed solutions. I have zero objection to paying for licenses to develop individual solutions and I can even tolerate maintaining a single general license for specific administrative overhead, its just that once any given solution is developed I have zero desire to pay for individual licenses to use specific solutions that I have developed, validated, and maintain control over.