Project and Portfolio Management Practitioners Forum
cancel

Check for users that have been disabled?

Highlighted
b460
Super Contributor.

Check for users that have been disabled?

Hi,

We have a couple of duplicate users in PPM and would like to filter by those which are enabled or disabled.

In the KNTA_USERS table there is no field that stores whether the user is enabled or disabled.

Does anyone know where this information is stored? I would like my SQL to check the database to see if the user is disabled.

Thanks.
2 REPLIES
Mahen M
Acclaimed Contributor.

Re: Check for users that have been disabled?

Hi,
If the user have end date less than SYSDATE then the user is disabled. If the End date is null or the end date is greater than sysdate then the user is enabled.
Thanks.

Regards,
Mahendran M
Sascha Mohr
Acclaimed Contributor.

Re: Check for users that have been disabled?

Or use the enabled_flag in the view knta_users_v