ORA-01031: insufficient privileges

From: Eugene <epipko_at_gmail.com>
Date: Tue, 14 Aug 2007 14:17:46 -0700
Message-ID: <1187126266.270240.261270@i38g2000prf.googlegroups.com>

Hi all,
Oracle 9.2.0.5. on Win2K3.

1. I loged in as user A and created a view my_view.
2. I loged in as user B and created a synonym for A.my_view.
3. Then I loged in as user A and granted Select on my_view to user B.
4. When I login as B and issue: Select * from my_view I am getting

ORA-01031: insufficient privileges.

Why? What can I check?

Thanks,
Eugene Received on Tue Aug 14 2007 - 16:17:46 CDT