[WFLY-2087] Ensure SUPERUSER and AUDITOR role can only be modified by SUPERUSER.

This PR needs to be reviewed by Brian, the changes to the test case show the intended change in behaviour is in effect but due to the importance of constraints I want Brian to have another check.