WL#7410: Migrate authentication tests in main suite

Status: Complete

This is about migrating security and authentication tests
in the main suite to use InnoDB instead of MyISAM.