Database & RLS
This lesson covers defining Row Level Security in PostgreSQL and the difference between USING and WITH CHECK.
Like a waiter who only sees the tables they serve — RLS ensures each user can only see and modify their own data.
- RLS
- Row Level Security — row-level access control in PostgreSQL that restricts access by user identity.
- USING
- The part of an RLS policy that defines which rows can be read (SELECT) and deleted (DELETE).
- WITH CHECK
- The part of an RLS policy that defines which rows can be inserted or updated (INSERT/UPDATE).
