Are There Specific ODI Database Privileges That Can be Used? (Doc ID 2016556.1)

Last updated on SEPTEMBER 29, 2015

Applies to:

Oracle Knowledge - Version 8.5.1 and later
Information in this document applies to any platform.

Goal

Are there any specific Oracle Knowledge ODI internal guidelines to not grant open ended rights to db users accessing the db? For example, for the ODI configuration, internal documentation indicates OKM_ODI_WORK requires the following access:
Roles: RESOURCE, CONNECT System Privileges: CREATE ANY TABLE, SELECT ANY TABLE ,INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE, DROP ANY TABLE, CREATE ANY INDEX, SELECT ANY SEQUENCE, ANALYZE ANY, UNLIMITED TABLESPACE Tablespace Quota: ALTER USER "ODI_ODI_WORK" QUOTA UNLIMITED ON USERS;


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms