FGAC predicate not taking effect.
Hi,
I have recently created FGAC policy on GL_JE_HEADERS table in Oracle Apps with the following function returning the Predicate
create or replace function f_policy_gl_fn
-- Function must have the following parameters
(schema in varchar2, tab in varchar2)
-- Function will return a string that is used as a WHERE clause
return varchar2 authid current_user
as
v_user varchar2(100);
out_string varchar2(400) default '1=2 ';
-- out_string will be the return value.
-- It is initialized to '1=2' because 'WHERE 1=2' means 'Nothing to access'
begin
-- get session user
v_user := lower(sys_context('userenv','CURRENT_USER'));