How to Create a User With Database Read Only Privileges For OIM Reports (Doc ID 2061558.1)

Last updated on MARCH 05, 2017

Applies to:

Identity Manager - Version 11.1.2.2.0 to 11.1.2.3.0 [Release 11g]
Information in this document applies to any platform.

Goal

Currently the official Oracle documentation states that the reports be configured using schema owner details of OIM and SOA

http://docs.oracle.com/cd/E40329_01/dev.1112/e27150/understanding.htm#OMDEV3573

Some clients do have restriction wherein the user should have only read only privileges to be used for configuring the reports. 

How to create a user with Read only privilege and also modify the report to work with such user?
 

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