Use the ALTER PROFILE
command to modify a user-defined profile; Advanced Server supports two forms of the command:
Include the LIMIT clause and one or more space-delimited parameter/value pairs to specify the rules enforced by Advanced Server, or u
se ALTER PROFILE
to change the name of a profile.
specifies the new name of the profile.
parameter specifies the attribute limited by the profile.
value specifies the parameter limit.
will count failed connection attempts when a login role attempts to connect to the server. The profile specifies that if a user has not authenticated with the correct password in three attempts, the account will be locked for one day.