Question:
Hi,
Need a report or file/table show all users versus all transactions for delete or cancel it (TrX), never use it in each profile...
Regards
Answer:
I do not think such a table or view exists. It sounds to me you want to check user trx history. In that case search this forum for trx history posts. That topic has been discussed at lenght here (I know b/c I asked that very question before).
Once you have your history compare that to the access your users have by merging AGR_USERS and AGR_TCODES tables.
Answer:
Simple:
1. Use the RBE tool to get a list of all transactions run per user
2. Create a list of all users with their transactions by combining AGR_USERS and AGR_TCODES
3. Find user with transactions not run