You can expire a user’s password immediately using the ALTER USER statement’s PASSWORD EXPIRE parameter.
By expiring a password, you can:
• Force users to comply with a change to password policy.
• Set a new password when a user forgets the old password.
This feature also comes in handy when you as an admin are asked to replicate users on one database to another. You can easily create the remote user, but how do you set the user’s password being that you don’t know the password? That’s where the PASSWORD EXPIRE parameter comes to the rescue. Simply create the user then expire the user’s password. This will require the user to set their password the next time they log on.
Example:
dbadmin=> CREATE USER jim;
CREATE USER
dbadmin=> ALTER USER jim PASSWORD EXPIRE;
ALTER USER
dbadmin=> \q
[dbadmin@s18384357 ~]$ vsql -U jim
The password has expired.
Changing password for jim
New password:
Retype new password:
Password changed.
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h or \? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
jim=>
Have fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
