Teradata DBC password change and Reset

How to change dbc password:

SMP001-01:~ # bteq

  Teradata BTEQ 15.10.01.09 for LINUX. PID: 6045

 Copyright 1984-2016, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

.logon/dbc

 .logon/dbc

Password:

  *** Logon successfully completed.

 *** Teradata Database Release is 15.10.06.06

 *** Teradata Database Version is 15.10.06.08

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

  *** Total elapsed time was 1 second.

  BTEQ -- Enter your SQL request or BTEQ command:

modify user dbc as password = dbc;

 modify user dbc as password = dbc;

  *** Database/User has been modified.

 *** Total elapsed time was 1 second.

  BTEQ -- Enter your SQL request or BTEQ command:

.QUIT

 .QUIT

 *** You are now logged off from the DBC.

 *** Exiting BTEQ...

 *** RC (return code) = 0

 

SMP001-01:~ # bteq .logon dbc,dbc

  Teradata BTEQ 15.10.01.09 for LINUX. PID: 7574

 Copyright 1984-2016, Teradata Corporation. ALL RIGHTS RESERVED.

 Enter your logon or BTEQ command:

 .logon dbc,

  *** Logon successfully completed.

 *** Teradata Database Release is 15.10.06.06

 *** Teradata Database Version is 15.10.06.08

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

  *** Total elapsed time was 1 second.

  BTEQ -- Enter your SQL request or BTEQ command:

 

How to Reset dbc password:

 If you have forgotten your dbc password then you will need to request Teradata Global Support Center, Database Software team to reset dbc password. They may utilize an internal procedure to reset this password. Therefore, careful to keep your password safe in repository so you don’t forget current password as Teradata will charge money for reset password and it also require maintenance window.

 It mentioned clearly in Terada document ID KCS000289

https://teradatanet0.teradata.com/Site001F/support/general/kcs.nsf/id/KCS000289


Comments