Advice on use of CREATE DIRECTORY
Hello All
I hope someone can provide some clarity on the function of the CREATE DIRECTORY command.
Situation is that I have decided to use the BFILE method to enable the delivery of thousands of relatively small, solely read-only JPGs and PDFs to my Forms 12.2.1.1 forms. Having read up on the pros and cons of BFILE v BLOB storage I think the former better suits my needs and the resources I have to sustain the solution, and we're ready for the extra system administration to ensure backup and recovery of the files which will be external to the database .
So to use these I understand I need to create a DIRECTORY OBJECT, that this needs to be owned by the SYS users, that I'll need to allocate READ only privileges on that object to public (so my users can see the files) and both READ and WRITE privileges to my main admin user so they may upload new images. I also understand that the CREATE DIRECTORY command does not physically create a directory, (that's my responsibility) and that it's purpose is to hold a synonym for the physical directory in which I will store my JPGs/PDFs, and that I