Project and Portfolio Management Practitioners Forum
cancel

Security group assigment - takingback log

Highlighted
danriz
Respected Contributor.

Security group assigment - takingback log

Hello;

I want to find out when a security group is given to a user and when a security group is taken back.

on KNTA_USER_SECURITY table there is current situation. But I could not find the logs.

Is there any way to find a user's past assigment to security groups?

 

If not I am considering to build an after delete, update,insert trigger. Is this trigger and new log table can cause a problem in the system?

 

1 REPLY
Jim Esler
Acclaimed Contributor.

Re: Security group assigment - takingback log

The table knta_user_security_hist may have the information you are looking for.