Solved

We had a big fight on this topic among my team members, please help on whether an image file is permanently deleted or can be rolled back to get it

Posted on 2011-02-26
4
207 Views
Last Modified: 2013-11-05
A team member said something, some supported and some deadly againsted, please help on make it clear :whether an image file is permanently deleted or can be rolled back to get it.

Here is the opinion which caused a big arguement:
"If a hacker can get into the database which hosts images, that means he can get that particular image eventually. Also if the image is cashed in any other website like google engine, that is also accessible by other users.Delete is a user function that does or does not do what the end user thinks it is doing."

We are obsulately not gurus, appreciate your input.

0
Comment
Question by:jc50967w
4 Comments
 
LVL 3

Expert Comment

by:gopisera
Comment Utility
Any deleted rows can be rollback.

I can't  get the question correctly.

Let me know  with clear details  

if the hacker get into the database???     In order to provide security we can use the wallet which provides security to the tablespaces

Thanks,.
0
 

Author Comment

by:jc50967w
Comment Utility
Thanks  Qopsera, I will provide more detailed info later.
0
 
LVL 38

Expert Comment

by:Jim P.
Comment Utility
First off -- storing images in a database is not recommended -- ever.

Second -- what and how long an image or any other data stays on the net is determined by Google and not by anything you do.

Third -- If the hacker has gotten to your database level (and already past your HTML/Web level) -- he pretty much can do whatever you have given access to the userid that is running your web connecvtion to the DB.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
Since this is strictly a philosophical debate:

IMHO, To store images in a database really depends on the images and how they are used.  I see no reason to not store say, mugshots tied to an arrest record, in a database.  Icons on a website, sure store them on the filesystem.

Back to the question.  'rolled back' is a specific database term.  I think you are really asking if the images can be 'recovered'.  The answer to that question is: It depends.

If you have proper backup and recovery, possibly.  It depends on what level of access the hacker obtains, their familiarity with the database product, how mischievous they wish to be, etc...

Say you do backups at 6:AM, someone inserts an image at 6:05 AM, I hack your database and delete this image at 6:10 AM and you don't discover the hack until 10PM.  Odds are the image is gone forever.

Now, if you had designed your system to 'archive' deleted rows say through a trigger or app code, you might be safe.  I say 'might' be because what if I don't 'delete' the image but drop tables/users/???.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now