Re: mview over private database link
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 27 Sep 2011 11:31:47 -0700
Message-ID: <CAORjz=NmFXNxoBxzZg22=tcKxZvp44yJ5pLxaABWnyug3xmzXw_at_mail.gmail.com>
On Tue, Sep 27, 2011 at 1:16 AM, Remigiusz Sokolowski < remigiusz.sokolowski_at_nordea.com> wrote:
>
> So it seems the TARGET user can select on rights of the MIDDLE user, but
> can not select for building a mview.
>
> Do You know how looks the big picture behind this?
>
>
It would appear that the rights for TARGET are granted through a role. TARGET needs explicit SELECT grants to the tables in the MIDDLE schema.
Date: Tue, 27 Sep 2011 11:31:47 -0700
Message-ID: <CAORjz=NmFXNxoBxzZg22=tcKxZvp44yJ5pLxaABWnyug3xmzXw_at_mail.gmail.com>
On Tue, Sep 27, 2011 at 1:16 AM, Remigiusz Sokolowski < remigiusz.sokolowski_at_nordea.com> wrote:
>
> So it seems the TARGET user can select on rights of the MIDDLE user, but
> can not select for building a mview.
>
> Do You know how looks the big picture behind this?
>
>
It would appear that the rights for TARGET are granted through a role. TARGET needs explicit SELECT grants to the tables in the MIDDLE schema.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 27 2011 - 13:31:47 CDT