authentication_integrations

The authentication_integrations table lists authentication integrations, authentication plugin types, configuration properties, and creation and modification details.

Note:

Supported since VeloDB Enterprise 4.1.4.

Database

information_schema

Columns

Column	Type	Description
NAME	varchar(256)	Authentication integration name.
TYPE	varchar(64)	Authentication plugin type, such as oidc.
PROPERTIES	string	Formatted integration properties. Sensitive properties are masked.
COMMENT	string	Integration comment.
CREATE_USER	string	User who created the integration.
CREATE_TIME	string	Creation time.
ALTER_USER	string	User who most recently modified the integration.
MODIFY_TIME	string	Most recent modification time.

Access control

Only users with ADMIN_PRIV can view data in this table. Other users can query the table, but the result is empty.

Examples

List all authentication integrations:

SELECT * FROM information_schema.authentication_integrations;

Find an integration by name:

SELECT name, type, properties, comment, modify_time
FROM information_schema.authentication_integrations
WHERE name = 'corp_oidc';

List all OIDC integrations:

SELECT name, type, create_user, create_time, alter_user, modify_time
FROM information_schema.authentication_integrations
WHERE type = 'oidc';

Usage notes

• PROPERTIES contains a formatted property string rather than the original SQL statement.
• Sensitive properties, such as password, secret, token, credential, and keytab, are masked.
• This table shows saved configuration. It does not indicate whether an integration has successfully authenticated a user or validated a token.

See also

• CREATE AUTHENTICATION INTEGRATION
• ALTER AUTHENTICATION INTEGRATION