Re: Right needed to open a BFILE

From: Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK>
Date: Fri, 09 Aug 2002 12:18:02 -0400
Message-ID: <3oq7lu4d63m0pkjnfvnjuqkbb8h4qc1bn0@4ax.com>

On Fri, 09 Aug 2002 11:49:37 -0400, Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK> wrote:

>I am trying to open a BFILE through PHP. The code works if I log in as
>sys, but not as a user I set up. So, I am trying to figure out what
>rights I need to give it.
>
>The error that is return is:
>
>
>Warning: OCILobFileOpen: ORA-22285: non-existent directory or file for
>FILEOPEN operation in .../test.php on line 6 (Line 6 is: OCIFetchInto
>($Query_Id, $Image, OCI_RETURN_LOBS);)
>
>I GRANTed EXECUTE ON DBMS_LOB to the user, yet it did not help. Is
>there some other right needed here?
>
>Brian

OK, figured it out finally. The user doesn't need EXECUTE on DBMS_LOB at all. The problem was the user needed READ on the DIRECTORY.

Brian Received on Fri Aug 09 2002 - 11:18:02 CDT