We have one project with several users, three roles (“operator”, “supervisor” and “admin”) and at least six clients (touch panels) installed around our plant.
We have successfully implemented the custom authentication by querying our SQL server, and all seems to working fine.
But recently our customer requires the following improvement: each operator must have different privileges depending on the client with which you logged in, but using the same username and password.
The database custom authentication allows to write custom queries to define users, roles and so on; but – we believe – is not possible to parameterize those queries.
How is possible to involve the host name (or IP or MAC address) in the security system?
Thanks in advance.