Question:
Hi All,
Is there a way to automate deactivation of users who have not logged on to the system for a long period? e.g. Lock all users who have not logged on to SAP system since last 90 days.
Thanks for the replies.
Regards,
Vijaya
Answer:
You will have to write your own utility for this.
Answer:
Any details, pointers?
Thanks,
Vijaya
Answer:
Ask an ABAPer to select all users who have not logged on in the last X days and are not lock them lock them. Really simple ABAP code
Answer:
In fact, you could create a really simple SQL query to run nightly to do it. Something like "UPDATE SAPR3I.USR02 SET UFLAG = 64 WHERE MANDT = '<client number>' AND TRDAT < SYSDATE - 90;" but get your ABAPer/SQL person to verify this since I just popped that out on the fly.
Answer:
For new users you can set asystem profile paramter to expire unused accounts after given date.
We chose not to use an automated system for exiting users because we need to check delegated PO Release authorities etc before deactivating a user. We often have people who change jobs (act in a new position for a few months) or go on long-term leave an they do not need to use SAP for a period.
I just run a report once a month, for users not logged n for 90 days and review the results. Base don that I delete rather than expirre the records. We count it as the cost of doing business.
_________________
Sandi
~~~~
Apparently Father Christmas, the Easter Bunny, the Tooth Fairy and Star Wars aren't real
Tuly kiwi.
Answer:
Take a look at the code of RSUSR200, or just use it?
Tarr