0 Replies Latest reply: Mar 26, 2013 2:41 PM by khenn RSS

    orasso.wwsso_audit_log_table_t access

    khenn
      When trying to run the following query from an APEX application as the APEX schema owner of the workspace, I always get No Data Found.

      select user_name,
      log_id,
      log_date,
      ip_address,
      action,
      message
      from orasso.wwsso_audit_log_table_t
      where user_name = :P26_USER_NAME;

      I cannot figure out the grants needed to make this work. It seems like there is some kind of behind the scenes fine grained access control, but for the life of me, I can't find it. Any help would be greatly appreciated. I'm actually trying to run the above query against the wwsso_audit_log_view, but since the table doesn't work either, I figured I'd start there.

      Kris