Need to create database id like apps but should have only read-only rigghts
We need to implement OBIEE, we understood that OBIEE requires to read the data from EBS tables
As per SOX policy we cannot provide apps users to OBIEE team.
We need to create an id (e.g. appsoth) which should have select rights on all the tables of EBS
Kindly help us to achive.
Thanks