On Mon, Oct 11, 2010 at 5:37 PM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > Schema A will have only select on Schema B. > This is at odds with your previous post: How do I absolutely stop schema A from accessing schema B’s objects? Perhaps some details and clarification are in order after you have a chance to solidify what you are really being asked to accomplish. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com