Can I have multiple database users within WordPress?

Just set a random user in your wp-config.php for each request:

$db_users = array(
    'user_1',
    'user_2',
    'user_3',
);

define( 'DB_USER', $db_users[ array_rand( $db_users ) ] );