Re: What privilege needs to be granted?

Ping wrote:
>
> In schema U2, the select count(*) from U1.T1 gives following error message:
>
> ERROR at line 1:
> ORA-01031: insufficient privileges

Your problem is therefore NOT in the PL/SQL routine. It is a basic accessibility problem.

Now might be a good time to reread the following documentation:

Oracle9i Database Concepts: Chapter 23
Oracle9i Database Administrator's Guide: Chapters 25, 23 & 24

both being available at http://docs.oracle.com (http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage) Received on Fri Jan 02 2004 - 19:20:51 CET