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 |
NNL-00933: Requests refused, OTHER-DATA violation: number
ORA-17510: Attempt to do i/o beyond file size
ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
NNL-00813: Average query processing time: string
TNS-00289: Navigator: Disabled Interchange
ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV
ORA-02035: illegal bundled operation combination
ORA-32141: get method does not match the type of the parameter
DRG-12605: datatype of column number in COLUMNS list is not supported
ORA-29387: no top-plans found in the pending area
PLS-00624: USING clause must be used with either aggregate or pipelined functions
ORA-03125: client-server protocol violation