Database Utilities (MOSC)

MOSC Banner

sys_context in fine grained audit not working

edited Feb 7, 2017 9:48AM in Database Utilities (MOSC) 3 commentsAnswered

I am trying to set up a FGA on a number of tables and want to limit the number of selects to audit by excluding internal selects in pl/sql packages and for that I am using SYS_CONTEXT feature. But, I can't get this to work at all and to make sure that it really doesn't work I did the simplest and most stupid example and it looks like this:

-- Create test table

create table MY_SCHEMA.TABLE_SYS_CONTEXT_TEST

(column1 varchar2(10),

column2 varchar2(10),

column3 varchar2(10),

column4 varchar2(10));

-- add FGA to be triggered where sql statement is null and that should be impossible

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