Re: What privilege needs to be granted?
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sat, 03 Jan 2004 12:19:29 +0100
Message-ID: <bt67ud$q1k$1_at_news1.tilbu1.nb.home.nl>
>
>
> 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)
Date: Sat, 03 Jan 2004 12:19:29 +0100
Message-ID: <bt67ud$q1k$1_at_news1.tilbu1.nb.home.nl>
Hans Forbrich wrote:
> 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)
Even worse, then - wonder what the "set of privileges which worked on oracle 8.1.6" were?
-- A prosperous 2004, Regards, Frank van BortelReceived on Sat Jan 03 2004 - 12:19:29 CET