Skip to content

Instantly share code, notes, and snippets.

@forus

forus/ora-force-change-own-pwd.sql

Created September 14, 2015 15:10
Show Gist options
  • Save forus/ae582f56805618db5648 to your computer and use it in GitHub Desktop.
Save forus/ae582f56805618db5648 to your computer and use it in GitHub Desktop.
Download ZIP
Add a flag to the user table to make a user change own password on next login.
Raw
ora-force-change-own-pwd.sql
--ORACLE version
ALTER TABLE SEARCHAPP.SEARCH_AUTH_USER ADD CHANGE_PASSWD NUMBER(1,0);
Raw
pg-force-change-own-pwd.sql
--PostgreSQL version
alter table searchapp.search_auth_user add change_passwd boolean;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment