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

Bepy wrote:
>
> 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 ?

You're probably looking at needing to use dynamic SQL here

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"