UserA has to grant privileges directly to UserB--no way around it that
I know of.
On 8/24/05, Jose Luis Delgado <joseluis_delgado_at_yahoo.com> wrote:
> DBAs...
>
> Sorry if this is a silly question, my brain is not
> thinking clearly today...
>
> 1.- UserA gives SELECT privileges on his tables to
> UserB trough a role RoleA.
>
> 2.- UserB creates ViewA, querying the UserA tables.
>
> 3.- UserB creates viewB, which query ViewA, in his own
> schema.
>
> He gets:
> ORA-01031 Insufficient privileges
>
> Of course, this is because of he cannot query the
> tables (through the role, right?) that the ViewA is
> pointing to...
>
> the point here is:
> What could be the best solution to give UserB enough
> privileges to query the view, without having a mess
> with privileges??
>
> Thanks in advance!
> JL
>
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 24 2005 - 16:55:39 CDT
