PL/SQL (MOSC)

MOSC Banner

FGAC predicate not taking effect.

edited Apr 30, 2015 3:03AM in PL/SQL (MOSC) 1 commentAnswered ✓

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'));       

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