5.3 Required Privileges for using GenAI

To perform the following GenAI functions, ask the admin user to grant you the required privileges:

To create a vector store, the FILE privilege is required:
```
mysql> GRANT FILE ON *.* TO 'user_name'@'%';
```
To run the batch queries using ML_GENERATE_TABLE, ML_RAG_TABLE, and ML_EMBED_TABLE, the following privileges are required:
- SELECT and ALTER privileges on the input table:
```
mysql> GRANT SELECT, ALTER ON input_schema.input_table TO 'user_name'@'%';
```
- SELECT, INSERT, CREATE, DROP, ALTER, UPDATE privileges on the schema where the output table is created.
```
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%';
```