Re: Question re view privileges
From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 10 Sep 2008 13:25:52 -0700
Message-ID: <bf46380809101325h220ef725k42e13f347d621242@mail.gmail.com>
Date: Wed, 10 Sep 2008 13:25:52 -0700
Message-ID: <bf46380809101325h220ef725k42e13f347d621242@mail.gmail.com>
On Wed, Sep 10, 2008 at 1:05 PM, William Wagman <wjwagman_at_ucdavis.edu>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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 10 2008 - 15:25:52 CDT