Data Governance and Security Basics

The Principle

Only give people access to the data they need.

Roles and Permissions

CREATE ROLE analyst LOGIN PASSWORD 'securepass';

GRANT SELECT ON orders TO analyst;

REVOKE UPDATE ON orders FROM analyst;

Row-Level Security (RLS)

Let users only see rows they are allowed to see.

ALTER TABLE orders ENABLE ROW LEVEL SECURITY;

CREATE POLICY see_own_orders ON orders FOR SELECT USING (user_id = current_user_id());

*Day 95: The SQL Interview Toolkit.*