Absent Member.. ScQuinn Absent Member..
Absent Member..
175 views

Force Users to Reset Passwords

Jump to solution

Is there a DB column that can be updated to require users to reset their passwords (when the user account in internal to PPM)?

 

We have a large amount of internal PPM users that we want to regularly require a reset of their password and would like to run a DB script to do this.

 

I know in the Workbench, you can do an individual user, but having a script would be much easier for us due to the large number of users in our implementation.

 

Thanks in advance.

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Absent Member.. randull Absent Member..
Absent Member..

Re: Force Users to Reset Passwords

Jump to solution

Hi,

 

That is correct. I should said that is better to back up the table in order to avoid any issue.

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
0 Likes
2 Replies
Absent Member.. ScQuinn Absent Member..
Absent Member..

Re: Force Users to Reset Passwords

Jump to solution

I think I found the answer - but would like confirmation:

 

Table: KNTA_USERS

Column: PASSWORD_EXPIRATION_DATE

 

So if that was set to sysdate for all users, that should require a mass reset of the passwords.

 

Is this correct?

 

Thanks.

0 Likes
Absent Member.. randull Absent Member..
Absent Member..

Re: Force Users to Reset Passwords

Jump to solution

Hi,

 

That is correct. I should said that is better to back up the table in order to avoid any issue.

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.