Add an option to turn alter table auto_increment off.

[3pointer]

Feature Request

Is your feature request related to a problem? Please describe:

We had this mechanism, when import table successfully, lightning will do alter auto_increment job to trigger TiDB to refresh its auto_increment cache due to TiDB issue https://github.com/pingcap/tidb/issues/2285. But sometimes we don't have a privilege to execute alter SQL. then lightning will return error.

Describe the feature you'd like:

Add an option to turn alter table auto_increment off.

Describe alternatives you've considered:

can we alse add an option to handle auto_random?

Teachability, Documentation, Adoption, Optimization:

[kennytm]

Can we just add that permission into the docs 🤔