ORA-30372: fine grain access policy conflicts with
materialized view
Answer / guest
Cause: A fine grain access control procedure has applied a
non-null policy to the query for the materialized view.
Action: In order for the materialized view to work
correctly, any fine grain access control procedure in effect
for the query must return a null policy when the
materialized view is being created or refreshed. This may be
done by ensuring that the usernames for the creator, owner,
and invoker of refresh procedures for the materialized view
all receive a null policy by the user-written fine grain
access control procedures.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-00207: controlfiles are not for the same database
PLS-00600: SAMPLE cannot be applied to a remote object
ORA-38473: cannot drop a type used for Expression Filter attribute set
ORA-22850: duplicate LOB storage option specificed
ORA-01617: cannot mount: string is not a valid thread number
ORA-00399: corrupt change description in redo log
ORA-31157: Invalid Content-Type charset
NNL-00807: Queries received, type SOA: number
NNC-00430: Database not accessible
ORA-19502: write error on file "string", blockno string (blocksize=string)
RMAN-04033: cannot open auxiliary parameter file string
[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table