FGA - Handler issue for a policy
Hello,
1. I have created a schema sysadmin_fga
2. Then created one policy AAA for this one, with the handler parameters.
3. The called procedure BBB initalizes a CLOB message, an email address and calls the procedure APPS.WF_MAIL.SEND (module WF) to send an email.
No problem of compilation.
But when trying to update the table audited by the policy, the error message appears:
1. I have created a schema sysadmin_fga
2. Then created one policy AAA for this one, with the handler parameters.
3. The called procedure BBB initalizes a CLOB message, an email address and calls the procedure APPS.WF_MAIL.SEND (module WF) to send an email.
No problem of compilation.
But when trying to update the table audited by the policy, the error message appears:
ORA-28144: Failed to execute fine-grained audit handler
ORA-00942: table or view does not exist
ORA-06512: at "APPS.WF_MAIL", line 8065
(Line 8065: raise ...)
In the trace:
Error during execution of handler in Fine Grained Auditing
Audit handler : begin SYSADMIN_FGA.BBB(:sn, :on, :pl); end;
0