A customer would like to set up a configuration with GeoMedia clients connected to SQL Server databases. The required configuration is the following :
How is it possible to achieve this configuration?
It is not possible with a single connection but GeoMedia does support SQL privileges. Just make sure you have assigned the correct privileges in SQL server. A read-only only user typically has only the DATAREADER role assigned. For example, you can make 2 connections with User A, one to the Read-Write database A (where User A is assigned full privilege) and one to the Read-Only database B (where User A is assigned DATAREADER privileges).
SQL privileges for each database can be assigned via the Security tab. Just assign the user the appropriate privilege for the database in question. A single user can have different types of access privilege for each database that exists.
The only caveat with the SQL server database is that each GeoMedia connection allows access to only one database.