Re: BFILE question

From: DA Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 04 Apr 2003 08:53:05 -0800
Message-ID: <3E8DB871.F2FDCD1F@exxesolutions.com>

barry wrote:

> Hi - can't seem to find anything about this in the on-line manuals but
> is there anyway that you can prevent users from
> deleting/renaming/editing files once they are referenced as a BFILE in
> an Oracle database table?
>
> For example, if there are two files names c:\bfiletest\test1.txt and
> c:\bfiletest\test2.txt, and I execute the following within Oracle,
> that the only file that users could then play with/delete etc is
> test1.txt. They couldn't edit or delete test2.txt.
>
> CREATE TABLE tbltest(a NUMBER, b BFILE);
> CREATE OR REPLACE DIRECTORY testdirectory AS 'c:\bfiletest';
>
> INSERT INTO tbltest VALUES(1,BFILENAME('TESTDIRECTORY','test2.txt'));
>
> Thank you
> Barry

Look at:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96591/adl12bfl.htm#897410

Daniel Morgan Received on Fri Apr 04 2003 - 10:53:05 CST