Create database USER ID - Create database USER ID - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
lifecycle
latest
Product Category
Teradata Tools and Utilities

In order to take advantage of IDT support, a database user ID needs to be created as follows:

  • The <userid> should be one of IBM z/OS logon User IDs.
  • The <userid> should be RACF authorized.
  • <userid> need to be created and granted with NULL PASSWORD as follows:
CREATE USER <userid> AS PASSWORD=<password>,PERM=0,SPOOL=1E9;
GRANT LOGON ON ALL TO <userid> WITH NULL PASSWORD;