Summary - Security and backup

Build a secure setup with GRANT and prepared statements.

Summary - Security and backup

Security and backup: PREPARE against SQL injection, GRANT/REVOKE for privileges, COPY TO for backup, COPY FROM for recovery. Least privilege and regular backups are core principles.

-- PREPARE -> GRANT -> COPY TO -> COPY FROM
-- en az yetki, düzenli yedek

Security and backup go hand in hand.

Exercise Summary - Security and backup

Summary task: give the reader role read access on orders.

Show example solution

GRANT SELECT ON orders TO reader;

Test yourself

Read permission

GRANT SELECT ON orders TO ____

Show answer

GRANT SELECT ON orders TO reader

What is used against SQL injection?
- INDEX
- TRIGGER
- PREPARE
- VIEW
Show answer

PREPARE — PREPARE is used against SQL injection.
Summary - Security and backup: match the terms

PREPARE

prepare
GRANT

grant
COPY TO

backup
PITR

point-in-time

Next lesson: Design challenge

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies