Can the OracleDB user have CREATE_SYNONYM instead of CREATE_TABLE privileges?

Document ID : KB000076456
Last Modified Date : 05/04/2018
Show Technical Document Details
Question:
  Can the OracleDB user (for the EM's backend DB) have CREATE_SYNONYM instead of CREATE_TABLE privileges?
Environment:
EM with Oracle backend DB
Answer:
  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.