Write answers for the following statements.
Post 1:
Database Security
Databases have become an influential part of personal and professional settings in modern
society. Maintaining security within databases is essential to protect the integrity of the
database and the privacy of the data. Database security “strives to ensure that only
authenticated users perform authorized activities at authorized times.”(pg.62). Database
security “...should not be only thought of as capturing of information but also as avoiding the
violation of particulars such as integrity, availability, and confidentiality.” (Bakir, & Guclu,
2022). Understanding database security and the techniques that support security are
important steps in database development and management. Two of the topics that Murray
(2010) identified that will be discussed within this post are access control and auditing. Other
topics Murray (2010) mentioned for database security include: vulnerability, application
access, and inference (Murray, 2010).
Access Control and Auditing Mechanisms
Access control “is the process by which rights and privileges are assigned to users and
database objects.” (Murray, 2020, pg.61). Controlling access helps to limit access to data
through authentication, assigning rights, and authorization practices (Murray, 2010). Access
can be granted or restricted to databases, tables, columns, or rows through access control
(Murray, 2010). Zhu, et.al., (2022) identified some outdated practices within access control
and started edge computing which uses cloud services and “real time migration” to achieve -
efficient access control and security (Zhu, et.al., 2022). The concerns Zhu et.al. (2022)
identified with older models of access control is that they have centralized authorization which
can create a single-point failure within the system (Zhu, et.al., 2022). Auditing mechanisms
“tracks database access and user activity providing a way to identify breaches that have
occurred so that corrective action might be taken.”(Murray, 2010, pg.61). Auditing is useful for
determining who accessed the database, what was changed, and what actions were carried
out to help identify breaches within the system (Murray, 2010). Auditing can look like viewing
logon attempts, changes in users, changes to database structure, changes to data, or errors
that occurred within the database (Murray, 2010). Audit trails are helpful for organizing the
information found within an audit.
Biblical Integration
Thessalonians 4:11 states to “and to make it your ambition to lead a quiet life: You should
