Learning path
Security & Access Control
pg_hba, roles and privileges, default privileges, RLS, search_path and SSL.
DBA, platform, security · Advanced · 1 course · 10 simulations
The path
Courses, then incidents
Work through the courses, then practise the incidents — each step links to its page.
- Course psql: The PostgreSQL Client →
- security-access pg_hba blocks the application →
- security-access Overprivileged application role →
- security-access Missing CONNECT privilege on the target database →
- security-access User has access to the wrong database →
- security-access Same role, different privileges per database →
- security-access Default privileges surprise →
- security-access RLS policy mistake →
- security-access Search path risk →
- security-access SSL requirement mismatch →
- security-access Audit trail missing →