Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

PASSWORD_LOCK_TIME

How do you change this (PASSWORD_LOCK_TIME ) to accept the password lock time to accept this setting in minutes/hour?

Comments

  • Hi Ramachandran

    As per vertica documentation the password_lock_time parameter can be set by providing the lock-period in no. of days & there is no documented way which can suggest that it can be set in hours/mins.

    Kindly check below syntax in order to perform the same:

    Syntax

    CREATE PROFILE name LIMIT [PASSWORD_LOCK_TIME {lock-period | DEFAULT | UNLIMITED}]
    or
    ALTER PROFILE name LIMIT [PASSWORD_LOCK_TIME {lock-period | DEFAULT | UNLIMITED}]

    Kindly check below documented link for deailed insights into this
    https://my.vertica.com/docs/6.1.x/HTML/index.htm#14955.htm

    Hope this answers to your query.

    Thanks
    Rahul
  • Sorry this does not answer my question. I was trying to find out if there was a way to change the setting of the password_lock_time, to accept in minutes/hours, as opposed to the current default of "in days".

    thanks

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.