FGA Condition Having Issue With Character Value signals ORA-28112
Last updated on OCTOBER 02, 2016
Applies to:Oracle Audit Vault and Database Firewall - Version 220.127.116.11 and later
Information in this document applies to any platform.
With the FGA policy condition as character, there is issue in the actual EBS form. However, it is working fine for numeric or without condition.
Following is an Example:
audit_condition=>'INFORMATION_TYPE = PERC_EXAMPLE',
audit_column=>'EX_INFORMATION1, EX_INFORMATION2, EX_INFORMATION3',
statement_types=>'SELECT, INSERT, UPDATE, DELETE',audit_trail=>DBMS_FGA.DB,
Once the policy is created, we get the below error :-
SQL> select count(*) from AV1.Example;
select count(*) from AV1.Example
ERROR at line 1:
ORA-28112: failed to execute policy function
Add FGA Policy.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms