Last updated on SEPTEMBER 29, 2015
Applies to:Oracle Knowledge - Version 8.5.1 and later
Information in this document applies to any platform.
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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms