Below is a guide as to which Teradata
database specific user passwords you can and cannot change (Teradata, 2017)
DatabaseName
|
OK
|
to Change?
|
$NETVAULT_CATALOG
|
NA
|
Database
|
ALL
|
NA**
|
Pseudo User No
password
|
CONSOLE
|
Y
|
Used in Teradata Manager Setup and Viewpoint
Setup
|
CRASHDUMPS
|
Y
|
OK to change but Teradata Support may request
password when working on the system
|
DBC
|
Y
|
|
DBCMANAGER
|
Y*
|
See Instructions below "Changing
DBCMANAGER Password for Teradata Manager"
|
DBCMNGR
|
NA
|
Database
|
DEFAULT
|
NA**
|
Pseudo User No
password
|
EXTUSER
|
NA
|
Pseudo User
|
NETVAULT1
|
Y
|
|
NETVAULT2
|
Y
|
|
PDCRACCESS
|
Y
|
NTA 3940 DR 179602 -
DIPPDCR / DIPPATCH may change the password of user PDCRAdmin and PDCRTPCD to
default
|
PDCRADMIN
|
Y
|
NTA 3940 DR 179602 -
DIPPDCR / DIPPATCH may change the password of user PDCRAdmin and PDCRTPCD to
default
|
PDCRCanary
|
Y
|
NTA 3940 DR 179602 - DIPPDCR
/ DIPPATCH may change the password of user PDCRAdmin and PDCRTPCD to default
|
PDCRtpcd
|
Y
|
NTA 3940 DR 179602 -
DIPPDCR / DIPPATCH may change the password of user PDCRAdmin and PDCRTPCD to
default
|
PUBLIC
|
NA**
|
Pseudo User No
password
|
SPOOLRESERVE
|
NA
|
Database or possibly customer specific
|
SYSADMIN
|
Y
|
OK to change but Teradata Support may
request password when working on the system
|
SYSDBA
|
Y
|
|
SYSTEMFE
|
Y
|
OK to change but Teradata Support may
request password when working on the system
|
SYSLIB
|
NA
|
Database
|
SYSUDTLIB
|
NA
|
Database
|
SYS_CALENDAR
|
N
|
But some customers report they have changed
this and not had any problems
|
TDMAPS
|
Y
|
|
TDPUSER
|
NA
|
Password not used to logon. User can be dropped if no mainframe
connection.
|
TDWM
|
Y*
|
TD 13.x and earlier (pre-Viewpoint), once changed
TDWM rules must be reactivated.
|
|
|
TD 14.x and higher (Viewpoint), the password
must be updated in Viewpoint URL.
|
VIEWPOINT
|
Y
|
Account is created manually on the database
side. On the portal side there is a username of admin
|
|
|
TD 14.x and higher (Viewpoint), the password
must be updated in Viewpoint URL.
|
LOCKLOGSHREDDER
|
Y
|
|
EXTERNAL_AP
|
Y
|
OK to change but not needed since it cannot
be used as a normal logon from a client. The logon will be rejected.
|
References
Teradata. (2017, 07 18). What are Teradata's Best
Practices & Procedures In Changing System Passwords? Retrieved from
http://knowledge.teradata.com/KCS/id/KCS006937 |