Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Jailing a schema from PUBLIC

Re: Jailing a schema from PUBLIC

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 13 Feb 2007 20:09:06 -0500
Message-ID: <9177895d0702131709ufee1476q79f44662f061d599@mail.gmail.com> 





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


Received on Tue Feb 13 2007 - 19:09:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US