What MySQL grants (on what table) for EA users?

[jakson]

I'm preparing to do properly the following:
1. migrate EA database from MySQL 4.x to MySQL 5.6.x (InnoDB)
2. enabling EA security
3. create EA users and groups (with sufficient privileges)
4. create MySQL users and groups (with sufficient privileges)

What MySQL minimal privileges should I grant (on what EA tables) for:
1. EA "read-only" user
2. EA "standard" user (can modify packages/objects/elements)
?

[qwerty]

insert/update/delete for all created tables. I think the EAlite user just need R access but it won't hurt to give him standard user rights as EAlite only sends read requests to the database. So user handling is easier.

q.

[Eve]

1. migrate EA database from MySQL 4.x to MySQL 5.6.x (InnoDB)

As part of this, check the versions of EA people are running. MySQL 5.6 requires a minimum of EA 11 build 1107. (For handling of the partition keyword)