Fix permissions for CodeQL workflows (#16660)
Fix permissions for CodeQL workflows (#16660)

After limiting permissions, our CodeQL workflow started failing.

This is because it needs some extra permissions as explained in
the https://github.com/github/codeql-action/issues/464

This PR adds the required permissions.
dhuang/incubator-airflow,mistercrunch/airflow,bolkedebruin/airflow,dhuang/incubator-airflow,apache/airflow,cfei18/incubator-airflow,cfei18/incubator-airflow,apache/incubator-airflow,Acehaidrey/incubator-airflow,nathanielvarona/airflow,Acehaidrey/incubator-airflow,Acehaidrey/incubator-airflow,cfei18/incubator-airflow,mistercrunch/airflow,apache/airflow,lyft/incubator-airflow,lyft/incubator-airflow,danielvdende/incubator-airflow,Acehaidrey/incubator-airflow,nathanielvarona/airflow,Acehaidrey/incubator-airflow,danielvdende/incubator-airflow,apache/airflow,nathanielvarona/airflow,bolkedebruin/airflow,apache/incubator-airflow,cfei18/incubator-airflow,dhuang/incubator-airflow,bolkedebruin/airflow,Acehaidrey/incubator-airflow,apache/incubator-airflow,dhuang/incubator-airflow,bolkedebruin/airflow,nathanielvarona/airflow,cfei18/incubator-airflow,apache/airflow,cfei18/incubator-airflow,danielvdende/incubator-airflow,mistercrunch/airflow,bolkedebruin/airflow,danielvdende/incubator-airflow,lyft/incubator-airflow,nathanielvarona/airflow,apache/airflow,lyft/incubator-airflow,apache/incubator-airflow,danielvdende/incubator-airflow,nathanielvarona/airflow,apache/airflow,mistercrunch/airflow,danielvdende/incubator-airflow