3 Replies Latest reply on Aug 3, 2011 7:50 PM by BB23

    FGAC with APEX 4.0.2?

      I recently threw APEX over an existing database I have to offer some custom reporting for a client. Any SQL Workshop queries or application reports return "no data found" though I can still see plenty in SQL Developer. I assume it has to do with the FGAC applied to my tables. I thought I configured the APEX workspace to use my existing schema as the same user as our application. In fact, a "select username from user_users" shows the user I expected, not APEX_PUBLIC or ANONYMOUS. Is there any special FGAC adjustment necessary for APEX to use FGAC data? I can't find much documentation crossing APEX and FGAC.

        • 1. Re: FGAC with APEX 4.0.2?
          http://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15517.pdf Is this not sufficient??

          Thank you,

          Tony Miller
          Webster, TX

          Never Surrender Dreams!

          If this question is answered, please mark the thread as closed and assign points where earned..
          • 2. Re: FGAC with APEX 4.0.2?
            No it's not. There is one paragraph on VPD and it's severely lacking.
            I see some older threads on VPD and APEX but they're full of 404 links and older APEX 2.2 talk.
            I see mentions of APEX's "VPD section" which looks like a page process section. I don't recall ever seeing it. It's definitely not available in the new tree view.

            Thanks for suggesting though.
            • 3. Re: FGAC with APEX 4.0.2?
              Ah -

              Aaaaand for when that page is a 404:

              Shared Components > Edit Security Attributes > Security

              Edited by: BB23 on Aug 3, 2011 2:49 PM