AutoProvision - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Determines whether unknown external logons (logons with no existing entry in the DBC.Dbase table) are automatically added as new users (CREATE USER) prior to the logon completing.

Field Group

General

Valid Settings

Setting Description
TRUE External logons from unknown users cause creation of new users (CREATE USER).
FALSE External logons from unknown users are logged on as user EXTUSER.

Default

FALSE

Changes Take Effect

After the DBS Control Record has been written.

Usage Notes

All new users created by auto provisioning are created under the special user External_AP, which logs on to the system only when required to run the CREATE USER command for new external logons.

Related Topics

For more information on auto provisioning of external logons, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.