Hopefully this is an easy one.
I am using MII 11.5 and I have it configured to use a JDBC connection to an Oracle table to look up user's roles. This has been working for a long time. I am now trying to add a priority column to my roles table so that I can have fine control over the roles relative priorites so that the user's menu gets put together in the order I want.
I thought this might simple be a matter of adding "order by priority" to my select statement that I already had for the "Select Roles for User" query in the JDBC configuration. I was hoping the order that the roles were returned from the query would be the order that MII would process them.
It looks like admin and developer roles get added to the menu first. This is not a problem for me. I just need to be able to control the order of the processing for the other roles. How do I do this?
I have already looked at the help pages.
Thanks,
Mike