That answer is probably true if you are solely using Optim Connect to control access to the Optim archive file.
We control access to Optim archive file datasources using a FAD (File Access Definition) on the archive file itself. You can allow or disallow this person whatever privileges you want on the data contained within the archive file using the FAD. Optim Connect seems to be quite fragile as far as tinkering with settings (change one thing, three other things stop working), so we use it mainly to define data sources to be discoverable to the ODBC Thin Client and that's it. If someone tries to create a Thin Client DSN that points to an Optim archive file datasource they aren't on the FAD for, their query will fail for denied access anyway.
Hope this helps. Send me a message if you want to discuss what we use for security and access on the archive files.
------------------------------
Keith Tidball
Progressive Insurance
------------------------------
Original Message:
Sent: Thu September 12, 2019 10:27 AM
From: Danny Lankford
Subject: Optim Connect Datasource Security
------------------------------
Danny Lankford
IT Manager
3M
MN
------------------------------
#InfoSphereOptim
#Optim