15.00 - SET EXTAUTH - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SET EXTAUTH

Purpose  

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

Syntax  

 

Value

Description

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 “Chapter 14 Gateway Control (gtwcontrol)” on page 627.

Note: If you have scripts that depend on the deprecated SET SSO command, you should change them to use the SET EXTAUTH command.

The new setting is effective immediately.

To check the current setting, use “GET EXTAUTH” on page 175.

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

For additional information on external authentication, see Security Administration.

Example  

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

set extauth only
 
The External Authentication mode has been set to ONLY.