how to migrate user password from 14.00 to 16.20

Database
Highlighted

how to migrate user password from 14.00 to 16.20

Hi,

 

I'm migrating Teradata database from 14.00 to 16.20.

I would appreciate If someone could teach me how to migrate the user passwords.

I confirmed the passwords are encrypted in DBC.DBase and it could not be extracted.

 

I'd like to migrate encrypted passwords in 14.00 Dbase to 16.20 Dbase.

Is this possible ?

 

Sincerely,

Setsuo Sato

 


Accepted Solutions
Supporter

Re: how to migrate user password from 14.00 to 16.20

Yes, it can be done, but is a complicated process.

You have to ARCHIVE DICTIONARY from one version, then RESTORE onto the next major release version.

Then follow that by running the new version upgrade scripts. (Teradata CS or GSC should be able to point you to them)

 

In your case you must do this twice, as you can only upgrade one major release. (14.x to 15.x, or 15.x to 16.x)

The whole process should be tested before applied to a production system.

 

There is no way to copy the user detail only. Best you can get is writing a SQL script to generate CREATE USERS from the old system and run on the new. But passwords cannot be read and would have to be set at initial dummy value, and required to be changed on initial logon.

Teradata Frank, Certified Master
1 ACCEPTED SOLUTION
4 REPLIES 4
Ambassador

Re: how to migrate user password from 14.00 to 16.20

Hi,

I'm not sure this is possible, at least not without GSC support.

Normally, the user definitions (including password) would be transferred when you transfer an existing DBC database from one system to another. This can only be done if there is only DBC on the target system.

You might have to talk to your Teradata team/GSC for help with this.

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Supporter

Re: how to migrate user password from 14.00 to 16.20

Yes, it can be done, but is a complicated process.

You have to ARCHIVE DICTIONARY from one version, then RESTORE onto the next major release version.

Then follow that by running the new version upgrade scripts. (Teradata CS or GSC should be able to point you to them)

 

In your case you must do this twice, as you can only upgrade one major release. (14.x to 15.x, or 15.x to 16.x)

The whole process should be tested before applied to a production system.

 

There is no way to copy the user detail only. Best you can get is writing a SQL script to generate CREATE USERS from the old system and run on the new. But passwords cannot be read and would have to be set at initial dummy value, and required to be changed on initial logon.

Teradata Frank, Certified Master

Re: how to migrate user password from 14.00 to 16.20

Dave-san,

 

Thank you for your helpful advice.
I will try to get GSC support for this issue.

 

Sincerely


Setsuo Sato

Re: how to migrate user password from 14.00 to 16.20

Teradata Frank san,

 

Thank you for your detailed explaination.
I can understand how complicate to transfer
passwords for another system.

 

I will try to find CREATE USER scripts on old system
or ask my customer for unknown passwords.

 

Sincerely,

 

Setsuo Sato