Am 02.11.18 um 12:00 schrieb Harald Paulsen:
2) We will use multiple perdition servers and only some users should
be allowed to use
one of the servers (while all of them are allowed to use the second one).
The addition of a WHERE-clause in the configuration would help make
this possible.
Example:
map_library_opt
dbserver:3306:dbPerdition:tblPerdition:perdition:perditionpassword:mailserver:email:NULL:SomeExtraField='Y'
If I was forced to implement something like this, I would create a
good-named VIEW in the database with the extra WHERE clause (given that
it is static). Of course it depends on where you prefer to have the
"business logic" of the decision who may use which server. This gives
some additional obstacle that the perdition database user cannot
accidentally be granted with write privilege to the actual table, and if
you ever have to change something in the table, you do not need to adapt
the perdition config.
Regards
Matthias