Insufficiente privileges querying my own views... 2005-08-24 - By Paul Baumgartel
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@(protected)> 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 (See ORA-01031.ora-code.com) 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@(protected)
--
http://www.freelists.org/webpage/oracle-l
|
|
