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.