Vertica Quick Tip: Expiring a User’s Password

Soniya Shah, Information Developer
February 22, 2018

This blog post was authored by Jim Knicely. 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...

Vertica Quick Tip: VSQL Shortcuts to Move Faster on the Command Line

Soniya Shah, Information Developer
February 22, 2018

This blog post was authored by Jim Knicely. vsql is Vertica’s character-based, interactive, front-end utility that lets you type SQL statements and see the results. If you’ve typed a particularly long query in vsql then realize that you’d have a typo way back at the beginning of your code (i.e. you wrote SEELECT), instead of...