Deleted user profiles in AS/400

20 pts.
Tags:
Application development
AS/400
AS/400 jobs
Backup and Recovery
CLP
DataCenter
IBM DB2
Security
Hi Is there any way we can know about deleted user profiles in AS/400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb

Answer Wiki

Thanks. We'll let you know when a new response is added.

Take a look at this command: dspaudjrne. I got this from the Search400 website. You may find the information helpful.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JDWWms
    If you have it turned on you can get the list from the Audit journal (QAUDJRN). Need to set several system values to make it work and you will wnat to implement a procedure to clean it up as it can take a lot of space.
    0 pointsBadges:
    report
  • TomLiotta
    If a profile is deleted, the system audit journal will record a deleted object, with entry type 'DO'. Unfortunately, there will probably be a lot of DO entries and very few will be user profiles. It is a reliable indication, but takes some sifting of the data. You'll also need to have a full month's worth of audit journal receivers on-line unless you capture entries on a daily or weekly basis as time passes. You could register a Delete User Profile Exit Program against the QIBM_QSY_DLT_PROFILE exit point. If nothing else, you could log the date/time to help with retrieval of the audit DO entry. Or you could simply generate a monthly list of user profiles. Whenever someone wants to know which profiles were deleted in a given month, just run an exception join against the lists before and after the month. One problem is that it won't catch profiles created and deleted in the same month. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following