Re: DBMS_RLS: Fine-Grained Access Control - Table name substitution

Thanks for previous answers.
Maybe I'm in the wrong path with FGAC...

The real problem is this: we have a master environment connected with others subsystems via dblinks. An interface program is responsible for loading data from specific subsystem in a run passing subsystem name (dblink) as parameter.
Since we don't want to duplicate queryies for every dblink, we built an "universal" view putting every base table from every dblink in union with others:
select 1 db_name, a.* from a_at_dblink1 a
union all
select 2 db_name, a.* from a_at_dblink2 a
union all
...

That way is good as long as *all* dblink are up&running, but if one of these become invalid (for example because Oracle goes down) the whole view become unusable (even if still valid).

Can anybody help ? Received on Thu Jul 10 2003 - 01:41:56 CDT