SET EXTAUTH - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

Controls whether Vantage users can be authenticated outside (external) of the Vantage software authentication system.

In scripts, change the deprecated SET SSO command to SET EXTAUTH.

Syntax

SET EXTAUTH { OFF | ON | ONLY }

Syntax Elements

OFF
Rejects external authentication logons; traditional logons are accepted.
ON
Accepts both external authentication and traditional logons. This is the default.
ONLY
Accepts external authentication logons only; traditional logons are rejected.

Usage Notes

External authentication may eliminate the need for your application to declare or store a password on your client system.

To configure how the network allows or disallows traditional and new external authentication logons, see Gateway Control (gtwcontrol).

The new setting is effective immediately.

To check the current setting, use GET EXTAUTH.

The SET EXTAUTH database command duplicates the functionality of the ExternalAuthentication setting in DBS Control. For more information on DBS Control, see DBS Control (dbscontrol).

For additional information on external authentication, see Teradata Vantageā„¢ - Analytics Database Security Administration, B035-1100.

Example: Setting the system to accept only externally authenticated logons

This example sets the system to accept external authentication logons only.

set extauth only

The External Authentication mode has been set to ONLY.