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@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 Bortel

Received on Sat Jan 03 2004 - 05:19:29 CST