Highlighted
Akif Saburi Trusted Contributor.
Trusted Contributor.
771 views

Disable PPM user from back-end (DB)

Jump to solution

Hi,

 

Is there a way to disable users from backend.  I need to disable huge number of users from PPM.  Its pain to do it from Workbench.  It will be great if I can disable the users by running SQL script.

 

Regards,

Akif

 

 

0 Likes
1 Solution

Accepted Solutions
Erik Cole Acclaimed Contributor.
Acclaimed Contributor.

Re: Disable PPM user from back-end (DB)

Jump to solution
Sure, just give them an end_date in knta_users.
4 Replies
Erik Cole Acclaimed Contributor.
Acclaimed Contributor.

Re: Disable PPM user from back-end (DB)

Jump to solution
Sure, just give them an end_date in knta_users.
Absent Member.. AlexSavencu Absent Member..
Absent Member..

Re: Disable PPM user from back-end (DB)

Jump to solution

also, it is very important to refresh the user cache using kCacheManager - some of the changes in user information are not picked up from the database until the user cache is refreshed.

 

cheers

alex


--remember to kudos people who helped solve your problem
dlinetsk
Visitor.

Re: Disable PPM user from back-end (DB)

Jump to solution

Guys,

 

Is there a way to end a user session - kick a user out.

 

If a user logged into the system, and we set end date to expire (disabling user) the user still able to navigate PPM and make changes - the user is not kicked out from the system. The change takes affect only after he logs out (or times out).

 

Any idea on how to force the user session end?

 

Thanks,

Dmitry

0 Likes
Absent Member.. Niraj Prabhu Absent Member..
Absent Member..

Re: Disable PPM user from back-end (DB)

Jump to solution
Do you have SSO enabled? If yes then you can work with network team to force the terminal to get logged off. PPM does not provide any way to force the user session to terminate. SSO timeout can help kill the session after inactivity.
Niraj P.
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.