Database Security Fundamentals

Introduction

Database security begins long before you type a GRANT statement. It starts with a set of principles that tell you what you are protecting, from whom, and how much access any given person or program should have. In this topic you will meet those principles: the CIA Triad (confidentiality, integrity, availability), the distinction between authentication and authorization, the principle of least privilege, and the layered approach known as defense in depth.

These ideas matter in COP4708 because every practical task later in the module is an application of them. Creating users and roles is authorization in action; using parameterized queries protects integrity and confidentiality; storing credentials outside your code and encrypting connections are defense-in-depth layers; and choosing a limited service account for an application is least privilege applied to software rather than people. If the principles are clear, the SQL and configuration choices stop feeling arbitrary.

As you watch, keep a running list of two things. First, which part of the CIA Triad each control protects, since many controls protect only one or two and you need combinations to cover all three. Second, where the database sits relative to other defenses: notice that the database is rarely the first line of defense, but it is often the last, which is why access control inside the database still matters even when a network firewall and an application layer stand in front of it.

Video 1: What is Database Security?

IBM Technology · 14:28 · 39,378 views · 4y ago · captions — Watch on YouTube

About this video

An IBM Technology overview focused specifically on securing databases rather than systems in general. Based on its title and accompanying database security guide, it is likely to cover what makes database data a high-value target, the categories of threats databases face, and the layers of controls commonly applied, such as access control, encryption, auditing, and monitoring.

Why this video

This is the most directly on-topic video for the module: it frames security around the database itself, which connects the general principles to the user, role, and connection work you will do later.

Video 2: Cybersecurity Architecture: Fundamentals of Confidentiality, Integrity, and Availability

IBM Technology · 12:34 · 353,319 views · 3y ago · captions — Watch on YouTube

About this video

Part of IBM's Cybersecurity Architecture series, this video explains the CIA Triad in depth: what confidentiality, integrity, and availability each mean, and the kinds of controls and tradeoffs associated with each. Expect concrete examples of how strengthening one property can weaken another, and discussion of where authentication and access control fit.

Why this video

It gives you a clear, well-illustrated treatment of the single framework this topic is built around, which you can then map onto database-specific controls yourself.

Video 3: Cybersecurity Architecture: Five Principles to Follow (and One to Avoid)

IBM Technology · 17:34 · 1,112,775 views · 3y ago · captions — Watch on YouTube

About this video

A widely watched walkthrough of core security design principles, presented as five to follow and one to avoid. Given the series and title, it very likely covers least privilege, defense in depth, and the rejection of security through obscurity, with reasoning about why each principle holds up in practice.

Why this video

Least privilege and defense in depth are named subtopics here, and this video explains the reasoning behind them rather than just stating them, which helps you justify access control decisions in your own designs.

How These Videos Support the Learning Outcomes

Together these videos build the conceptual base the rest of the module depends on. The CIA Triad video and the security principles video directly support MO1 by explaining confidentiality, integrity, availability, and least privilege as frameworks rather than slogans. The least privilege and defense-in-depth discussion also sets up MO2, since roles, GRANT, and REVOKE are the mechanisms by which least privilege and separation of duties are enforced inside a database, and MO4, where a limited service account, external credential storage, and encrypted connections each form a separate defensive layer. The database security overview previews the threat categories behind MO3 and MO5, including injection attacks and the risks of shared or improperly isolated connections. None of the videos walk through SQL syntax or connection pool configuration, so expect the readings and lab work in this module to supply those hands-on steps.

About These Videos

These videos were chosen from YouTube on October 2, 2026. Each has captions; the player turns them on. Videos on YouTube can be changed or removed — if one no longer plays, tell your instructor. If a player does not appear, use its Watch on YouTube link.