Hallo,
I have a question on the required privileges in an Oracle database for use with odi.
I have created a user on a oracle database(D) called "ODI_Temp".
This account is used to connect odi to the database.
CREATE USER ODI_TEMP
IDENTIFIED BY oditemp1
DEFAULT TABLESPACE ODI_TEMP
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
ALTER USER ODI_TEMP DEFAULT ROLE ALL;
I have two schema's other schema’s in the database (D) called dm and dwh.
These have objects odi needs to use. Therefore I granted the following permissions.
GRANT CONNECT TO ODI_TEMP; --enable acess
GRANT RESOURCE TO ODI_TEMP; -- enable temp objects
GRANT ANALYZE ANY TO ODI_TEMP;
GRANT COMMENT ANY TABLE TO ODI_TEMP; -- dd descriptions
GRANT CREATE ANY TABLE TO ODI_TEMP; -- create in other schema
GRANT CREATE VIEW TO ODI_TEMP;
GRANT DROP ANY TABLE TO ODI_TEMP; -- create in other schema
GRANT INSERT ANY TABLE TO ODI_TEMP; -- create in other schema
GRANT SELECT ANY TABLE TO ODI_TEMP; -- create in other schema
GRANT DELETE ANY TABLE TO ODI_TEMP; -- create in other schema
GRANT UPDATE ANY TABLE TO ODI_TEMP; --- only dml in other schema
GRANT ALTER ANY TABLE TO ODI_TEMP; --- only DDL in other schema
GRANT UNLIMITED TABLESPACE TO ODI_TEMP;
Are there any other object types created by odi? (type’s, array's, view’s?)