Re: Jailing a schema from PUBLIC

Hey rjamya,

Do you mean that for this statement:

SELECT * FROM schema_a.table_1_at_remote_db;

...that the ALL_* views are needed in the "remote_db" schema pointed to by the dblink in order to gain access to that table?

There's a lot of ALL_* views to modify to try this out, but I'll give it a shot.

Hopefully your somewhat near Wisconsin (aka "The Beer State"), USA if this works! :)

Rich

> wild idea,
>
> since public access is visible through ALL_* views, you can create local
> ALL_* views in schema B. These would be essentially same as regular views
> but you'd filter out owner A.
>
> like I said, it is a wild idea. if it works, I'll take a beer.
> rjamya
>

--
http://www.freelists.org/webpage/oracle-l