Example: UPDATE Statement to Set Maximum Failed Logon Attempts - Teradata Vantage - Analytics Database

You can use this statement to set the maximum number of failed logon attempts to 3:

    UPDATE DBC.SysSecDefaults SET MaxLogonAttempts = 3 ;

You must have the DROP USER privilege to run the MODIFY USER statement.

For a discussion of the GRANT statement, see Working with User Privileges in Teradata Vantage.