Discussion Locked

database securety

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
hi i want to know about database securety in general can u help me please.

2 replies

by archon285

There are two aspects - allowing only people who should have access to the database see the data, and making sure that the data does not vnaish form the computer.

Most database programs will allow you to set passwords for different levels of access e.g. a master one for who ever set up the datasbase, so that they can make changes to the whole structure of it, andother level which enables people to enter and amend data (but not to change the structure) and a thrid level which only allows youto view the data. You need to consider who should have what access, once you have the system working.

Secondly, you want to be sure that in the event of machine breakdown the system can be up and running again without delay. I would suggest making a daily backup using either a Zip drive or a CD re-writer. Just make a copy of everything on a daily basis and then ensure that the copy is taken away from the site. If everything is destroyed by fire or flood then but a new machine, and loadit up. Running again in 20 minutes after the machine is installed. At worst you will have lost the data for one day, and you can reconstruct that, one hopes, from the paperwork.

There are more sophisticated methods, but the principles are the same: lock people out, and preserve the data.

Hope that is helpful

Archon285@aol.com

by pxttocyob

Yes, in general it means making your database secure. That means telling it that you won't trade it in for any other databases anytime soon. And wrap your computer up in a nice warm blanket at night. This will make it feel more secure.

This discussion is closed to new replies.