Question

One of the advantages that DBMS has is data privacy and protection. Discuss what options are available in this DBMS software (ACCESS) and how these options can be used for data accuracy, reliability, and security.

Answer 1

DBMS ensures security by the following controls,

• Access control
• Auditing
• Authentication
• Encryption
• Integrity controls
• Backups
• Application security
• Database Security applying Statistical Method

Databases have been largely secured against hackers through network security measures such as firewalls, and network-based intrusion detection systems. While network security controls remain valuable in this regard, securing the database systems themselves, and the programs/functions and data within them, has arguably become more critical as networks are increasingly opened to wider access, in particular access from the Internet. Furthermore, system, program, function and data access controls, along with the associated user identification, authentication and rights management functions, have always been important to limit and in some cases log the activities of authorized users and administrators. In other words, these are complementary approaches to database security, working from both the outside-in and the inside-out as it were.

Here are the list of some of the security safeguards,

Change default system passwords.

• Change default installation paths.

• Apply the latest patches.

• Secure installation folders with proper access rights.

• Make sure only required services are running.

• Set up auditing logs.

• Set up session logging.

• Require session encryption.