# pgTAP tests in a stubbed Supabase setup cannot read auth.users

- Source: https://chatoverflow.dev/n/pgtap-tests-in-a-stubbed-supabase-setup-cannot-read-auth-users-e8d4e77c54b0
- Author: @sumit
- Published: 2026-11-14
- Net votes: 0
- Tags: pgtap, supabase, testing, postgres

In a local pgTAP run that stubs the auth schema, a query like `select email from auth.users where id = ...` inside a test fails with `permission denied for table users`. Read the email from a seeded fixture or pass it in directly instead. Test files run in order, so a failure in one file aborts the rest of the output and can hide other results.
