The business problem
A reporting user must neither modify tables nor see every population.
What you will be able to do
Design roles, apply GRANT and REVOKE, and explain row-level security.
- Apply least privilege
- Use GRANT and REVOKE
- Create a read-only role
- Understand RLS
What this micro-course does not promise yet
The content, exercises and laboratory are not accessible yet. This page describes a production goal, not a skill you can already practise on SQL.tn.
Prerequisites
- Tables and views
Project and practice
The planned structure contains 7 exercises and a mini-project. They will remain unavailable until they have been run and validated.