Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.frii.net!newsfeed.frii.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@exxesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: BFILE question
Date: Fri, 04 Apr 2003 08:53:05 -0800
Organization: EXE
Message-ID: <3E8DB871.F2FDCD1F@exxesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
References: <747f1dec.0304040746.1ff48820@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 25
Xref: newsfeed1.easynews.com comp.databases.oracle.server:182017
X-Received-Date: Fri, 04 Apr 2003 09:53:51 MST (news.easynews.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