Re: problem with view

Dear Daud11,

I don't have the time to test it for you, but maybe you require the select-privilege WITH GRANT OPTION in order to grant userB SELECTprivileges  on the underlying tables of your view. My guess is that that should work for sure.

Cheerio,

Alexander Wendel, The Netherlands.

In article <8eqkvr$ft5$1_at_nnrp1.deja.com>,   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.
>
> regards
> Daud11
>
> btw. I am using Oracle 7.3.4
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

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