Thanks for the reply.Â
How do I get the menu items to show?
If the menu items are not showing, that suggests these role names are missing from the menu_acl table. You can make the menu items show up by inserting the roles in the menu_acl table with an 'allow' authorization and the menu ids of the menu items as taken from the menu_node table.
This seems a bit strange - if I need to change which items various users can access surely I don't have to edit the underlying database?