Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> BFILE question
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