Reporting menus and functions available to a responsibility
Our Auditors have asked us to provied a list of the menus and functions available to each responsibility (yes, I know that's going to be a long list).
I don't think the SQL will be entirely simple to write as the menu definitions appear to be resursive and the query needs to take account of exclusions.
Does a report already exist for this, or has anyone done it before? Or should I get my thinking cap on and write it myself?
Thanks,
Ian