Setting up user privileges for UNIX on 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