[Sqlalchemy-tickets] Issue #4239: engine.execute does not commit grant request (zzzeek/sqlalchemy)

[Alexis B <iss...@bi...>]

New issue 4239: engine.execute does not commit grant request
https://bitbucket.org/zzzeek/sqlalchemy/issues/4239/engineexecute-does-not-commit-grant

Alexis B:

We using postgresql 9.6.8 tried to add rights to a role.

It's not considered as a ddl query thus it does not issue a
commit at the end of the query.

This query issues a rollback:
```
engine.execute("GRANT SELECT ON ALL TABLES IN SCHEMA sch TO rol;")
```

This query works:
```
engine.execute(text("GRANT SELECT ON ALL TABLES IN SCHEMA sch TO rol;").execution_options(autocommit=True)) 
```

Shouldn't grant be considered as a ddl statement?