Skip to content

Instantly share code, notes, and snippets.

@JustinMcNamara74

JustinMcNamara74/netezza_reset_user_password.sql

Created December 20, 2016 19:25
Show Gist options
  • Save JustinMcNamara74/a927d270fef5c2aa4fc269e41c44acc4 to your computer and use it in GitHub Desktop.
Save JustinMcNamara74/a927d270fef5c2aa4fc269e41c44acc4 to your computer and use it in GitHub Desktop.
Download ZIP
Reset a user's password
Raw
netezza_reset_user_password.sql
-- This will force the user to enter a new passowrd upon the next login. User needs to know currentl PW.
-- http://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.adm.doc/c_sysadm_password_expiration.html
ALTER USER User EXPIRE PASSWORD;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment