RE: Question re view privileges

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Wed, 10 Sep 2008 13:29:41 -0700
Message-ID: <2A8185DC02A8CE4C8413E0A26A8A831A010079F9C9@XEDAMAIL2.ex.ad3.ucdavis.edu>


One learns something new every day, I did not know this. Thank you.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Wednesday, September 10, 2008 1:26 PM To: William Wagman
Cc: oracle-l_at_freelists.org
Subject: Re: Question re view privileges

On Wed, Sep 10, 2008 at 1:05 PM, William Wagman <wjwagman_at_ucdavis.edu<mailto: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-l Received on Wed Sep 10 2008 - 15:29:41 CDT

Original text of this message