Re: Oracle 9i and Unix-Filesystem

From: FlameDance <FlameDance_at_gmx.de>
Date: Thu, 24 Jun 2004 17:17:00 +0200
Message-ID: <cber9b$kh0$02$1@news.t-online.com>

Silver schrieb:
> Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<lbrgd055da3vmfukjjphfhbd31i7lgkd78_at_4ax.com>...
>

>> Did you grant access to the directory to the user, i.e. grant read on
>>directory dir_name to <user>?

>
> The user has all necessary rights and privileges (dba role!). Thanks.

Just a wild guess: In your original posting you have quotation marks around your commands. Could it be you're using dynamic SQL? In that case you'd need to grant the right explicitly, granting it through a role isn't sufficient for dynamic SQL. (One of the little quirks that aren't documented - or at least it escaped my search. It makes sense, though, for security reasons.)

Stephan Received on Thu Jun 24 2004 - 10:17:00 CDT