Can the OracleDB user have CREATE_SYNONYM instead of CREATE_TABLE privileges?

book

Article ID: 76456

calendar_today

Updated On:

Products

APP PERF MANAGEMENT CA Application Performance Management Agent (APM / Wily / Introscope) CUSTOMER EXPERIENCE MANAGER 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.