3 Replies Latest reply: Sep 24, 2012 5:36 AM by Harm Joris ten Napel-Oracle RSS

    ORA-28112 while testing FGA

    963842
      Hi gurus
      I'm testing the FGA and getting below error.
      ORA-28112: policy function or package HR.POLICY_FUNC has error

      What may be the reason for it, some time ago it was working.
        • 1. Re: ORA-28112 while testing FGA
          415289
          what trace file saying

          28112, 00000, "failed to execute policy function"
          // *Cause: The policy function has one or more error during execution.
          // *Action: Check the trace file and correct the errors.                                                                                                                                                                                                                                                                                                                                                                                                                           
          • 2. Re: ORA-28112 while testing FGA
            921598
            ORA-28112 results if SELECT or DML is performed on a table with an associated policy function and the policy function has policy-related errors.
            Check your policty function , is it in "valid" status?

            Regards
            Inam Bukhari
            http://dbmentors.blogspot.com
            • 3. Re: ORA-28112 while testing FGA
              Harm Joris ten Napel-Oracle
              Hi

              unfortunately this error from the support perspective is usually classified as a 'user error' :) but of course
              we can help you find the cause, there are some troubleshooting references in MOS here:

              How To Diagnose Error ORA-28112 (Doc ID 751850.1)
              How To Resolve ORA-28110 or ORA-28112 On SELECT Or DML (Doc ID 69401.1)

              Another simple test I recommend is to execute the policy predicate function independently
              and see if the value it returns makes any sense, so any issues may become clear:

              select HR.POLICY_FUNC('user','object') from dual;

              Please note we are currently actively promoting the new support communities also, so if you want to get some
              feedback from your peers as well as the attention of Oracle support engineers, please go to

              https://communities.oracle.com/portal/server.pt/community/database_security_products/338

              This will put you in the Database Products Security community , but you can select others also from the left,

              Greetings,

              Harm ten Napel
              Oracle Support