steampipe plugin install auth0

Table: auth0_hook - Query Auth0 Hooks using SQL

Auth0 Hooks are customizable scripts executed as part of the Auth0 pipeline, allowing you to customize the behavior of Auth0. They are written in Node.js and can be used for a variety of purposes, such as enriching user profiles, denying access based on custom rules, or even integrating with other services. Hooks are a powerful tool for extending the functionality of Auth0.

Table Usage Guide

The auth0_hook table provides insights into Hooks within Auth0. As a DevOps engineer or security analyst, explore hook-specific details through this table, including trigger, script, and associated metadata. Utilize it to uncover information about hooks, such as those with specific triggers, the content of the script, and the status of the hook.

Examples

Enabled hook scripts

Analyze the settings to understand the active hook scripts in your Auth0 environment. This can help in managing and troubleshooting your authentication workflows.

select
id,
name,
dependencies,
trigger_id,
script
from
auth0_hook
where
enabled;
select
id,
name,
dependencies,
trigger_id,
script
from
auth0_hook
where
enabled = 1;

Post change password script

Review the configuration for post-password-change procedures to assess the elements within your authentication system. This allows you to pinpoint the specific locations where changes have been made, enabling better security management.

select
id,
name,
script,
dependencies,
enabled
from
auth0_hook
where
trigger_id = 'post-change-password';
select
id,
name,
script,
dependencies,
enabled
from
auth0_hook
where
trigger_id = 'post-change-password';

User registration scripts

Analyze the settings to understand the status and dependencies of user registration scripts in Auth0. This could be beneficial in managing and optimizing the user registration process.

select
id,
name,
script,
dependencies,
enabled
from
auth0_hook
where
trigger_id in ('pre-user-registration', 'post-user-registration');
select
id,
name,
script,
dependencies,
enabled
from
auth0_hook
where
trigger_id in ('pre-user-registration', 'post-user-registration');

Schema for auth0_hook

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
dependenciesjsonbUsed to store additional metadata.
enabledbooleanEnabled should be set to true if the hook is enabled, false otherwise.
idtext=A unique ID for the hook.
nametextThe name of the hook.
scripttextA script that contains the hook's code.
trigger_idtextThe extensibility point name. Can currently be any of the following: credentials-exchange, pre-user-registration, post-user-registration, post-change-password.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- auth0

You can pass the configuration to the command with the --config argument:

steampipe_export_auth0 --config '<your_config>' auth0_hook