Question:
Does anyone have/know a list of all the AGR* tables that we should check on regularly?
Answer:
None, the tables can house garbge and it will not effect the user's access.
Answer:
Then, why does someone ask me if I have good knowledge of all AGR* tables. This is not an interview question, but asked by a friend of mine. He does not know about Security, but it seems he heard that security guys will know a lot about AGR* table. I usually dont get much into these tables.
Answer:
AGR tables help in analysing your security. If you have not created your roles correctly, the reports can spit out garbage. Ie if you are manually inserting objects or changing the standards to CHANGED. Then the reports don't always reflect reality. Again these tables should just help in analysing what is in your system
Answer:
Then, why does someone ask me if I have good knowledge of all AGR* tables. This is not an interview question, but asked by a friend of mine. He does not know about Security, but it seems he heard that security guys will know a lot about AGR* table. I usually dont get much into these tables. The answer is in your comment He does not know about Security, Knowing the tables can help in analysis, but it also requires knowing the data. Certain setting in the records mean "ignore" the data even though the record is there...
Answer:
I used AGR_AGRS, AGR_USERS ...