Select Statement Fails With ORA-06598: Insufficient INHERIT PRIVILEGES Even As SYS

(Doc ID 2343260.1)

Last updated on JANUARY 02, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

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

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