Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01031: insufficient privileges
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 gettingORA-01031: insufficient privileges.
Why? What can I check?
Thanks,
Eugene
Received on Tue Aug 14 2007 - 16:17:46 CDT
![]() |
![]() |