Select Statement Fails With ORA-06598: Insufficient INHERIT PRIVILEGES Even As SYS (Doc ID 2343260.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

The following  select statement  is failing :

SELECT COUNT(request.request_id) num_grants, org.state_id
  FROM request,
  organization org,
  custom_list_value custom459577
  WHERE request.grantmaker_id = utluser.constant_value('xxxxx')
  AND org.grantmaker_id = utluser.constant_value('xxxxx')
  AND request.organization_id = org.organization_id
  AND request.proposal_type_id = utluser.constant_value('xxxxx')
  AND custom459577.custom_field_id = xxxxx
  AND custom459577.parent_table_name = 'request'
  AND custom459577.parent_primary_key = request.request_id
  AND custom459577.value = xxxxx -
  GROUP BY org.state_id),
  sites AS(
  SELECT SUM(TO_NUMBER(REPLACE(req_met.target_value,',',''))) num_sites, org.state_id
  FROM request,
  organization org,
  custom_list_value custom459577,
  request_metric req_met
  WHERE request.grantmaker_id = utluser.constant_value('xxxxx')
  AND org.grantmaker_id = utluser.constant_value('xxxxx')
  AND request.organization_id = org.organization_id
  AND request.proposal_type_id = utluser.constant_value('xxxxx')
  AND custom459577.custom_field_id = xxxxx
  AND custom459577.parent_table_name = 'request'
  AND custom459577.parent_pr

fails with:

WHERE request.grantmaker_id = utluser.constant_value('xxxxx')
  *
ERROR at line 252:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "UTLUSER.CONSTANT_VALUE", line 1

The user xxxxx will own the mview.
The user xxxxx was granted the below privileges - 
grant create tale to xxxxx;
grant create mv to xxxxx;
grant query rewite to xxxxx;
grant select on request to xxxxx;
grant dba to xxxxx;

But the select statement does NOT run as sys either.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.