problem with view

From: <daud11_at_hotmail.com>
Date: 2000/05/04
Message-ID: <8eqkvr$ft5$1@nnrp1.deja.com>#1/1

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