how to list the frequency of use of a transaction and the role to which they are assigned for a user?
I need to create a sqvi to sort out my assigned roles.
I need to know:
the roles assigned to a user
the presence of transactions in roles
the frequency of use of the transaction.
I have used the tables agr_users , agr_1251 and ztransac_usage_m but the result is not good because more than 160000 hits and roles not assigned to the user.