I would suggest using views to control access
In my experience storing and retrieving images from MS SQL is significanly slower compared to pulling images via a file system. I use ADO stream object to retrieve the images and stream them directly to the end user browser, I do not use a temporary file. Too hard to come up with unique names for the temporary file for each user, plus you have clean up of the temporary files. --------------------------------------------------------------------------- ---------------------------------------------------------------------------
