Re: problem with view

In article <3911954F.93565111_at_pestilence.net>,   Job <Job_at_pestilence.net> wrote:
> daud11_at_hotmail.com wrote:
>
> > Hi
> >
> > Problem description:
> > I created a view MyView under schema userA. MyView is created from
> > tables own by other users. Before I created MyView, I got each of
 the
> > owner of the tables to grant 'select with grant option' to userA.
> >
> > While connected as userA, I grant select on MyView to userB.
> >
> > And here is the problem:
> > connected as userA:
> > select count(*) from MyView - return a number of rows
> >
> > connected as userB:
> > select count(*) from userA.MyView - return 0 rows.
> >
> > Anybody knows what should I check or where I could have gone wrong.
> >
>
> UserB also needs the 'select with grant option'
>
>

I don't believe UserB needs the 'select with grant option' on MyView. My guess would be that userA needs to take advantage of the 'select with grant option' he was given on the tables that comprise the view and 'grant select' to userB on each of those tables. That's a long winded way of saying that userB needs select privilige on the tables in the view. Hope this helps.

Later .....
Patrick

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu May 04 2000 - 00:00:00 CDT