On Wed, Sep 10, 2008 at 1:05 PM, William Wagman <wjwagman@xxxxxxxxxxx>wrote: > ORA-01031, insufficient privileges is returned. In order to resolve this > schema Y had to > > SQL> grant select on v1 to X with grant option; > > It has worked this way for quite a long time. SELECT privs on T1 have been granted to X Y as the owner of T1, does not intend for X to share this data with Z, or anyone else. Y has to explicitly allow X to share this data, which is why the 'grant option' is needed for X to allow Z to see the view V1. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist