Allow OAC cache clear with selective privilege rather than BI Service Administrator

Rajeshvig - Oracle

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): NA

Description (Required):

Refer Doc ID 2406210.1 / https://www.ateam-oracle.com/post/clearing-the-cache-using-the-rest-api-for-oracle-analytics-cloud-oac-classic

Solution provided for scheduled cache clear requires BI Service admin if it is possible to limit privilege to required level that would help keep solution it will help

We tried running by granting below privileges in OAC Classic but its not working.

Issue SQL Directly

Edit Direct Database Analysis

Execute Direct Database Analysis

Use Case and Business Need (Required):

Bi cache clear in OBIEE is required to reflect current data state in some cache and we use it as a scheduled operations to avoid recurrent user tickets, giving development user access to cache clear through scheduled analysis without making them admin will offload a lot of admin operations

Enhancement Request / Service Request: