ORA-30372: fine grain access policy conflicts with materialized view [message #689826] |
Fri, 10 May 2024 14:50 |
wtolentino
Messages: 420 Registered: March 2005
|
Senior Member |
|
|
when attempting to create a materialized view that is based on a view for which the view is based on a table on a remote database. it is throwing an error "ORA-30372: fine grain access policy conflicts with materialized view". the table on the remote view has FGA that is currently disable yet it is still throwing "ORA-30372".
SQL> select object_name, policy_name, enable
2 from dba_policies where object_name = 'WRT_COVID19_SE_STAGING';
OBJECT_NAME POLICY_NAME ENABLE
------------------------------ ------------------------------ --------------------
WRT_COVID19_SE_STAGING CODE_WRT_COVID19_SE_STA_POL_00 NO
SQL>
CREATE MATERIALIZED VIEW PEBTOWNER.PEBT_AGENTAPP_PEBT4_MVW
REFRESH FORCE ON DEMAND
AS
SELECT *
FROM WRT_COVID19_SE_STAGING sestag
WHERE sestag.project_grp_nbr IN (1250,1251,1255,1260,1261,1265)
ORDER BY CHILD_NYSSIS_ID,SCHOOL_BED_TXT
Error report -
ORA-30372: fine grain access policy conflicts with materialized view
30372. 00000 - "fine grain access policy conflicts with materialized view"
*Cause: A fine grain access control procedure has applied a non-null policy
to the query for the materialized view.
WRT_COVID19_SE_STAGING is a synonym for WRT_COVID19_SE_STAGING view. The view is based on a remote table "WRTDBA.WRT_COVID19_SE_STAGING@wrtd".
|
|
|
|
|
|
|