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_at_yahoo.net>
Date: Fri, 02 Jan 2004 18:20:51 GMT
Message-ID: <3FF5B618.219166C4_at_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 - 19:20:51 CET