Has anyone used SuiteAnalytics Connect (ODBC) and successfully restricted access to one subsidiary? Or, monitored access somehow? Even NS help says it doesn’t support Role based restrictions.

I feel like in this case, it's probably simplest to push into separate databases/tables using stored procedures in SQL and then have the users permissions live there to the different data sets.

In this case it’s only one subsidiary that is using the data warehouse. Subs are owned by parent but operating completely separately. And, they don’t want sub connecting ODBC to have access to other sub. I told them to build a Rest connection. But, they are literally about to go live and have no time to build/re-configure.