ORA-30372 fine grain access policy conflicts with materialized view

Main Menu

Resources

Your Ad Here

Resources

Random Errors

ORA-00153: internal error in XA library

Cause: The XA library could not access thread-specific pointers.

Action: Contact customer support.

Random Errors

ORA-00155: cannot perform work outside of global transaction

Cause: The application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction.

Action: Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set nolocal=f in the xa_open string or start a global transaction prior to attempting the work.

Joomla Templates

ORA-30372 fine grain access policy conflicts with materialized view

Problem: A fine grain access control procedure has applied a non-null policy to the query for the materialized view.

Solution: : 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.