Table schema:
CREATE TABLE table_name_89 (role VARCHAR, teams VARCHAR)

Question: What role has the team of Troyes AC Grenoble Foot?
SQL: SELECT role FROM table_name_89 WHERE teams = "troyes ac grenoble foot"