Title: Week 14
Course: Introduction to Database Management Systems

Database Security

The topic aims to introduce you to foundational elements of database security. This is a continuation of the previous topic on database administration. The focus is on exploring database security threats and their countermeasures, as part of database administration.

Learning Outcomes

At the end of the week, you will be able to:
1. Describe security threats relating to databases.
2. 2. Discuss and demonstrate the application of countermeasures to database security threats.

Over to you
The previous week focused on database administration. This week is a follow up by looking at database security. While this topic is the last, it is equally important for its aim is to learn about how to secure databases, as part of database administration.

Pre-Topic
You will need to have completed the activities from the database administration week (13) and understood the concepts. If needed, you may review the week content again to ensure a thorough understanding. Additionally, complete the survey found this week.

Due date Tuesday 23:59
Estimated study time: 1 hour

FACE-TO-FACE

- Highlight concepts related to database security.
- Think, pair, share on the concepts covered in the YouTube video.
- Work on a group discussion on a Mini Case study inline with DML

Task
1. Demonstrate how: Database backups can be performed.
2. User access rights can be allocated and removed from users on database objects.

E-TIVITIES

E-tivity 14.1 (Mandatory)

This week we have concentrated on database security. As an individual, you will perform the tasks listed below based on the running case. At this point, you must appreciate the power of the running case that has been a successive build up on the e-tivities leading to this final e-tivity

Task 1

A new learning resource “ Database Security ” has been provided to you for this week’s e-tivity. You may be fascinated with the concepts and terminologies presented in the book. Skim read through the book as you summarize and capture important concepts. The aim is not to replicate the notes but to note unique points of interest.

 Task 2

Based on what you have learnt through task 1 and in reference to the database that we have been building throughout the course, perform the following:

1. Schedule a differential database backup to be occurring every day at midnight.
2. Schedule a full database backup to be occurring every after 7 days at midnight.
3. Create a user called “viewer”. Assign the user read only rights to any one of the tables in the database.
4. Remove the read only rights from the user on the initially assigned table.

Be sure to capture any SQL statements executed plus the screenshots of the steps and outcomes in an MS-Word document for submission. Based on your submission, the instructor will extract key aspects and will give feedback to you.

Due date Sunday 23:59
Estimated study time: 6.5 hours

Keep a copy of your work in your e-portfolio folder.

ASSESSMENT