CREATE  view RRV_FE_AREA as 
select * from FE_AREA 
where (exists (select * from fe_v_grp4currentuser where groupname=?WH_USER?) 
and area_code>= 1)
 and exists (select 1 from fe_entity_by_user where r_name in (select groupname
 from FE_V_GRP4CURRENTUSER) and entity_name = ?RRV_FE_AREA?) with check option

Поделитесь материалом с коллегами и друзьями