Setting up user privileges for Oracle

So that the ccmdb commands work correctly, you must set up an Oracle user who has the privileges to perform the tasks involved.

Procedure

  1. Ask the sys or system user do the setup.
  2. Give the Oracle user the following privileges:
       CREATE USER
       DROP USER
       CREATE ANY INDEX
       DROP ANY INDEX
       CREATE ANY SEQUENCE
       ALTER ANY TABLE
       CREATE ANY TABLE
       INSERT ANY TABLE
       DROP ANY TABLE
       DELETE ANY TABLE
       SELECT ANY TABLE
       UPDATE ANY TABLE
       GRANT ANY OBJECT PRIVILEGE
       SELECT ANY SEQUENCE

Feedback