1 person found this helpful
What version of TimesTen is this (ttVersion command)? GroupRestrict is only supported on very old versions (7.0 and earlier). There are new (and better) security mechanisms available in 11.2.1 onwards.
If you are still on 7.0 or earlier then you should note that:
- The value specified for GroupRestrict is a single group name, not a list of group names.
- The value takes effect at the time the physical database is created and is fixed for the life of the database. To change it you must drop the database thus losing all its contend - so backup or save with ttMigrate first if you wish to preserve the contents), change the setting in sys.odbc.ini and then re-create the database.
- To use GroupRestrict the TimesTen daemon must run as 'root' (which is generally considered undesirable).
The error you are seeing is because the database was created with one value (or no value) for GroupRestrict and now you are trying to connect using a different value.
Thank you very much for a such detailed answer!
We have TimesTen Release 22.214.171.124.0 and now it's clear why we have this issue.