Measures to reduce security threats
Data and File protection - logical controls

Collision handling

c_dbdem0.jpg (16614 bytes)

In a multi-user database, two users may try to update the same record at the same time. For example, in a flight reservation system a seat may be vacant for two booking clerks so they enter the data and a collision occurs when the data is to be committed to the database.

Encryption

Whenever information is sent over a network, the possibility of unauthorised access exists. To overcome this businesses encrypt, ie code messages.
To understand the implications of encryption see the movie "Sneakers" - stars Paul Newman.

File locking

Special attributes can be given to files. For example;

Read only (the file can be read, but not altered in any way)
Hidden (the file will not appear in the directory window)
A password added to the file to limit access to authorised people
In MS-Windows File manager (see diagram)
- Select the file you wish to view the properties for
- Select File | Properties

fm_prop0.jpg (14752 bytes)

Other

Fire protection
Environment protection (eg. Humidity)
Passwords
Off-premise storage
File reconstruction plan
Insurance protection
Data Base Management Controls (Data Base Administrator - should be carefully monitored ie. clear job description, no transaction initialisation, have a backup assistant)

Measures to reduce security threats Data and File protection - logical controls

Collision handling

Encryption

File locking

Other

Measures to reduce security threats
Data and File protection - logical controls