Re: problem with view

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' Received on Thu May 04 2000 - 00:00:00 CDT