Re: What privilege needs to be granted?

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 02 Jan 2004 18:20:51 GMT
Message-ID: <3FF5B618.219166C4@yahoo.net>

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 - 12:20:51 CST