The following steps are recommended to alleviate the issue.
When using a read-only user for Oracle, the schema must be specified.
Create a text file in the analytics backend folder (next to the analytics-backend.jar)
Example: ae_schema.sql with the following content:
ALTER SESSION SET CURRENT_SCHEMA=uc4 This will set the schema to "uc4" while still using the configured db username and password.
Enable the following setting in the application.properties: datasource.ae.schema=file:ae_schema.sql.