Best Practices & Procedure in changing System Password in Teradata Database

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

Comments