Why access control protects data in MySQL - Quick Recap

Recall & Review

beginner

What is access control in databases?

Access control is a security method that limits who can see or change data in a database. It helps keep data safe by allowing only authorized users to access it.

beginner

Why is access control important for data protection?

Access control protects data by preventing unauthorized users from viewing or changing sensitive information, reducing the risk of data leaks or damage.

intermediate

Name two common types of access control in databases.

Two common types are: 1) Role-Based Access Control (RBAC), which assigns permissions based on user roles, and 2) Discretionary Access Control (DAC), where owners decide who can access their data.

beginner

How does access control help in real-life situations?

It ensures that only employees with the right permissions can see or edit customer information, protecting privacy and preventing mistakes or fraud.

beginner

What could happen if a database has no access control?

Anyone could see or change data, leading to privacy breaches, data loss, or unauthorized actions that harm the business or users.

What does access control in a database do?

A Speeds up database queries

B Deletes old data automatically

C Limits who can view or change data

D Backs up data regularly

Access control limits who can view or change data to protect it.

Which of these is a type of access control?

A Role-Based Access Control

B Data Compression

C Query Optimization

D Indexing

Role-Based Access Control assigns permissions based on user roles.

What risk does lack of access control create?

A Faster data retrieval

B Unauthorized data access

C More storage space

D Better user interface

Without access control, unauthorized users can access sensitive data.

Who decides access permissions in Discretionary Access Control?

A Database engine

B All users equally

C System administrator only

D Data owners

In DAC, data owners decide who can access their data.

How does access control protect customer privacy?

A By restricting data access to authorized users

B By deleting customer data regularly

C By sharing data with all employees

D By encrypting the database only

Access control restricts data access to authorized users, protecting privacy.

Explain in your own words why access control is important for protecting data in a database.

Think about who should see or change data and why.

Describe two types of access control and how they help protect data.

Consider who decides permissions and how they are assigned.