sql / intermediate
Snippet
Column-Level Data Abstraction via Database Views
Database views obscure sensitive table columns like salaries or personal identity numbers. They expose only necessary fields to application users, enforcing least-privilege security principles.
snippet.sql
sql
1
2
3
4
CREATE VIEW v_public_employee_directory ASSELECT employee_id, first_name, last_name, department_idFROM employeesWHERE status = 'ACTIVE';
Breakdown
1
CREATE VIEW v_public_employee_directory AS
Declares a virtual query wrapper table accessible to application users.
2
SELECT employee_id, first_name, last_name, department_id
Explicitly selects non-sensitive attributes while omitting restricted columns.
3
FROM employees
References the underlying base table containing complete employee records.
4
WHERE status = 'ACTIVE';
Filters out terminated or archived worker rows automatically.