Database Security Products (MOSC)

MOSC Banner

Application_contexts in unified_audit_trail not shown

edited Sep 3, 2015 10:02AM in Database Security Products (MOSC) 2 commentsAnswered

Hello,

i created application context like:

create context AF_INFO USING SYSAD.P_AF_CONTEXT;

Then inside the package i set the context like

CREATE OR REPLACE PACKAGE BODY SYSAD.P_AF_CONTEXT AS

  PROCEDURE set_context (content IN VARCHAR2, p_rc OUT NUMBER)

IS

  BEGIN

    DBMS_SESSION.set_context('AF_INFO','INFO',content);

    p_rc:=1;

  exception

  when others then

    p_rc:=-1; 

  END;

END P_AF_CONTEXT;

Then i have a user (audit_test), which i want to audit fully. One thing i want to store is the defined application context.

declare

a number;

begin

sysad.p_af_context.set_context('ivo2',a);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center