Right needed to open a BFILE

From: Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK>
Date: Fri, 09 Aug 2002 11:49:37 -0400
Message-ID: <4so7lu87ce493tv4b78jtm0l5egcoqpgrb@4ax.com>

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 Received on Fri Aug 09 2002 - 10:49:37 CDT