Can the OracleDB user (for the EM's backend DB) have CREATE_SYNONYM instead of CREATE_TABLE privileges?
Environment
EM with Oracle backend DB
Resolution
No - the EM requires that the user account for Oracle have create_table privileges so that it can create its daily aggregation tables. A user with only create_synonym will fail, and the EM log will fill with table creation failure messages.