Database log over User information

(0) Share

Report

Posted on by Community Member

Client wants to Capture changes made (added, changed and deleted) in AX users (Table SysUserInfo / Userinfo) and also added/deleted user-Group relations (Table UserGroupList). I define the logging for these tables in Database Log Setup but changes are nod captured into log.

Checking in AOT or SQL side records are created and deleted in these table, but Database Log do not capture the changes. What might be reason for this behaviour?

Other tables logging ( InventTable for example) works fine.

All responses (5)

Answers (0)

André Arnaud de Cal... 294,095 Super User 2025 Season 1 on at

Like (0)

Report

RE: Database log over User information

Hi Fred,

Some global system tables do show log values only in the DAT company. Have you tried switching to the DAT company? It has been a long time ago since I got this question. I do recall indeed some drawbacks on the table(s) you mention.
Community Member on at

Like (0)

Report

RE: Database log over User information

Why you think I want to change system objects - I do not?? Regarding changes, mentioned in initial question, I mean new, deleted or changed recors in the tables.

I want to use standard Database log over these tables and it does not work - I'm asking If anyone knows why this functionality do not work with UserInfo / UserGroupList tables? As simple as that!
Brijen S. Shah 292 on at

Like (0)

Report

RE: Database log over User information

Hi FredViidul,

Sorry but I don't understand how are you making changes on UserInfo / UserGroupList tables as there are System Objects and cannot be changed.

Regareds,

Brijen S. Shah
Community Member on at

Like (0)

Report

RE: Database log over User information

Yes Database log is standard functionality - my question is why this standard functionality do not work?

If I switch it in for UserInfo / UserGroupList, Database log does not record any changes I made in these tables :(
Brijen S. Shah 292 on at

Like (0)

Report

RE: Database log over User information

Hi FredViidul,

This is a standard functionality of AX. Moreover UserInfo table is a system table so you cannot make any changes on this table to enable CreatedBy, CreatedDateTime, ModifiedBy and ModifiedDateTime.

You can customize SysUserInfoDetail form and add your code to write method of UserInfo dataset and SecurityRole dataset.

Regards,

Brijen S. Shah