On Fri, Mar 14, 2014 at 11:38 AM, Paul McNett <[email protected]> wrote:
> > 2. Potentially insecure. I know you can lock down the data via group >> policies etc and we did in fact do this when we used a "pointer system" but >> it is a potential insecurity. >> > > Perhaps the database is potentially insecure, too? > ------------ > I can lock down a column for HR that nobody can see, yet users can query against it. > > 3. Data in a filesystem if present is by nature by definition insecure >> once accessed as files can be moved, renamed etc. >> > > I wasn't thinking the *user* would have direct access to the files. > --------------- > They are only a key fob or usb HD away from taking those documents as well. > Files are files. By putting them in the database you are essentially > reimplementing the filesystem there. I could see some benefits to doing > this, but I'm not sure they outweigh the cons of losing all the filesystem > tools at my disposal. ---------------------- No not all. AS you query for the documents pointers in a RDBMS you can just loin to them at the same time and not only get the document name, but the document as well. Next pint you can define an audit system to track who looked at and what if any changes were ever made to said document. you don't get that out of the file system. <triger in the document table> When you work with bank documents, contracts, etc. this is handy. You may also need to present that at a hearing as well if you are being investigated. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+rhoc-r87qcxd_juejiubgqczs4fxtrbqngndbwpq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
