Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> BFILE question

BFILE question

From: barry <bbulsara23_at_hotmail.com>
Date: 4 Apr 2003 07:46:53 -0800
Message-ID: <747f1dec.0304040746.1ff48820@posting.google.com>


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 Received on Fri Apr 04 2003 - 09:46:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US