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}]
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".
Comments
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
thanks