Question:
Is there a table that stores the number of auth objects contained in roles?
Answer:
You could get the number from AGR_1250
Answer:
AGR_1250 is your best bet. Just be sure to make note of the value in the DELETED field. If it is X then the particular authorization has been deactivated in the role and there not present in the actual profile. But perhaps you want to count these as well?
_________________
E. Kirk Beacham
Answer:
Note that the values in the AGR_xx tables may not be accurate. The ARG_xxx tables have no real meaning until the role is generated and no other changes where made. If you are in the habit of leaving the role WITHOUT genreatign then the values do not reflect the real access and could show more or less access.