-- return Y or N if the permision combination is valid with the user credentials
  function writePermision(p_u_id number, p_g_id number,
                          u_write varchar2,
                          g_write varchar2,
                          o_write varchar2) return varchar2 is
  begin
    if ((o_write='Y') or 
        (g_write='Y' and sys_context('cms_context','group_list') like '%|'||p_g_id||'|%') or
        (u_write='Y' and p_u_id=sys_context('cms_context','user_id'))) then
        return 'Y';
    else
        return 'N';
    end if;
  end writePermision;

  -- return Y or N if the permision combination is valid with the user credentials
  function adminPermision(p_u_id number, p_g_id number,
                           u_admin varchar2,
                           g_admin varchar2,
                           o_admin varchar2) return varchar2 is
  begin
    if ((o_admin='Y') or 
        (g_admin='Y' and sys_context('cms_context','group_list') like '%|'||p_g_id||'|%') or
        (u_admin='Y' and p_u_id=sys_context('cms_context','user_id'))) then
        return 'Y';
    else
        return 'N';
    end if;
  end adminPermision;

end cms_security;