I once took the time to investigate what customizing tables were used behind business role configuration and more specifically the navigation bar profile related tables.
Based on this research I have been able to create some useful queries related to SAP CRM Authorization administration. I elaborated these queries in my previous blog posts related to the usage of UIU_COMP.
But now, in order to actually "visually" SEE how this works, I think you might benefit from the file I actually created for this whole purpose.
It's basically some sort of table diagram including screenshots so you know and understand how this all fits together.
SAP University Team - SAP Articles by and for SAP Users