Archives of the TeradataForum

Message Posted: Fri, 12 Aug 2000 @ 02:58:31 GMT

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

Claudia,

Actually, you should not be able to simply cycle through a set number of passwords and back to the original password all in the same day. You cannot reuse a password for a number of days as determined by the parameter Password Reuse in the DBC.SysSecDefaults table.

The following is taken from the Security Administration manual:

The security administrator sets up the password features for a Teradata RDBMS by updating columns of a single row in user DBC table DBC.SysSecDefaults. The single row in the table is read by the Teradata RDBMS at system startup. The software uses the values in the columns to determine whether the option has been selected. Note: The system must be restarted to read the DBC.SysSecDefaults table and to make changed values operational. The rules selected apply to all users attempting to log on to the Teradata RDBMS, regardless of the logical client system from which the logon is received. The only override to the rules is the null password option, which allows a user to log on without a password and bypass all rules pertaining to user authentication. Password Expiration Allows the security administrator to define a time span during which a password is valid. After the time elapses, the user must change the password.

Password Reuse
This feature, which complements the password expiration feature, allows the security administrator to define the time span that must elapse before a previously used password can be reassigned to a user.

Maximum Logon Attempt
Defines the number of erroneous sequential logon attempts a user is allowed before the user is locked to further logon attempts.

Password Lockout Time
Sets the user lock time duration after the user has exceeded the maximum number of logon attempts.

Miscellaneous Password Features
Allow the security administrator to restrict the number of characters in the password, and to control the use of digits and special characters.

Sam Mosley,
President
VLDB Systems, Inc.

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