Add a few more tests for roles.

Check ER_GRANT error.

Check distinct sources of privileges.