Write Short notes on: (i) Security and authentication in database

(i) Security and Authentication in Database:

Database security refers to the collective measures used to protect and secure a database from illegitimate use, malicious threats, attacks, and loss of data. It involves a wide range of security controls, from access control to encryption, to ensure the confidentiality, integrity, and availability of the data.

Authentication, on the other hand, is a process that is used to verify the identity of a user, device, or system. It is a crucial aspect of database security as it helps in preventing unauthorized access to the database.

There are several methods of authentication, including:

1. Password-based authentication: This is the most common method where users provide a secret password to verify their identity.

2. Biometric authentication: This method uses unique biological characteristics of the user like fingerprints, facial recognition, etc.

3. Two-factor authentication: This method requires two separate methods of identity verification. For example, something the user knows (password) and something the user has (a one-time code sent to their phone).

4. Certificate-based authentication: This method uses digital certificates to authenticate a user or a device.

In a database system, both security and authentication work hand in hand to protect the data from unauthorized access and potential breaches. While security measures protect the database from threats and attacks, authentication ensures that only authorized users have access to the database.