Query: Connections with sign-up disabled

Description

Explore which connections have not disabled the sign-up option, providing insights into potential areas of vulnerability or increased traffic. This can be useful for identifying and managing potential security risks or resource allocation.

Query

Tables used in this query:

• auth0_connection

SQL

select
  id,
  name,
  strategy
from
  auth0_connection
where
  options ->> 'disable_signup' = 'false';

select
  id,
  name,
  strategy
from
  auth0_connection
where
  json_extract(options, '$.disable_signup') = 'false';