-- Verify auth_service_user can access the tables
SELECT schemaname, tablename FROM pg_tables WHERE schemaname = 'auth';
SELECT COUNT(*) as user_count FROM auth.users;
SELECT COUNT(*) as session_count FROM auth.sessions;
SELECT COUNT(*) as mfa_count FROM auth.mfa_settings;
SELECT COUNT(*) as refresh_token_count FROM auth.refresh_tokens;
