Can the OracleDB user have CREATE_SYNONYM instead of CREATE

Can the OracleDB user have CREATE_SYNONYM instead of CREATE_TABLE privileges?

Article Id: 76456

Status: Published

Updated On: 05-04-2018 11:59

Products:

CA Application Performance Management Agent (APM / Wily / Introscope) , INTROSCOPE

Issue/Introduction:

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.