09-02-2007 6:36 PM
Hi
I have 1200 roles in system. I want the list of roles which got expired ( validity date ) need to do some housekeeping job..can any one help me out .
Thanks
SR
09-02-2007 8:37 PM
From memory table AGR_USERS has start-end dates for roles assigned to users. This will give you all roles that are assigned to users but their validity dates have passed
10-23-2007 1:32 PM
Hi Alex,
any idea how to mass delete all roles from a user master which are not valid "today"?
Is there any report or function module?
Cheers,
Andreas
10-23-2007 3:55 PM
Hi,
You can use PFUD transaction code to adjust the user master records. However, the PFCG_TIME_DEPENDENCY job that run every night will do this job. Check if that job is active or not.
Regards,
Mahee
<b><removed by moderator></b>
Please use your SDN Business Card for your website, email address, etc.
10-23-2007 9:00 PM
Hi Andreas,
I'm not aware of any tool that will remove the role from the UMR. You could knock up a catt script to delete the role via SU10 (SU10 will allow you to perform the removal based on the role name & the valid dates).
Maheedhar G - you may want to be careful about your sig, the mods here aren't too keen on advertising...........
10-23-2007 9:07 PM
I am seeing sig with this website from the past few days .. Are they paying for advertisement? getting $$$$$ is alwyas a good idea lol
Thanks
Prince Jose
10-24-2007 6:51 AM
Hi Maheedhar G,
for my opinion PFUD checks the relationsship role - profile. But the program will not delete roles with an expiry date from the user master.
Thankx Alex. I hoped to hear that there is any standard functionality that delete roles from the user master which are "invalid by date".
Somebody has any kind of program ready???
Cheers
Andreas