Archives of the TeradataForum

Message Posted: Wed, 21 May 2014 @ 17:29:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Most user's passwords in my company expire after 45 days except service accounts.

I found an article from Teradata website that I can change PasswordReuse value in DBC.SysSecDefaults with this command.

     UPDATE DBC.SysSecDefaults SET PasswordReuse = XXX;

Since I don't want users to reuse their 24 previous passwords if I set the PasswordReuse value to 1080 (24 * 45) it should work.

Is there any negative side effect in changing this value in SysSecDefaults table?

James Park
Database Specialist

	<Prev	Next>		<<First	<Prev	Next>	Last>>