MySQL HeatWave User Guide

6.3 MySQL HeatWave AutoML Privileges

To use MySQL HeatWave AutoML, ask the admin user to grant you the following privileges. Replace user_name and database_name in the commands with the appropriate user name and database name.

Database Privileges

You need the following privileges to access the database that stores the input tables (training datasets). 

mysql> GRANT SELECT, ALTER ON database_name.* TO 'user_name'@'%';

You need the following privileges to access the database that stores the output tables of generated predictions and explanations. 

mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%';

Lakehouse and Tracking/Monitoring Privileges

You need the following privileges to access external Lakehouse tables that have machine learning datasets, and to track/monitor the status of AutoML and AutoML routines.. 

mysql> GRANT SELECT ON performance_schema.rpd_tables TO 'user_name'@'%';
mysql> GRANT SELECT ON performance_schema.rpd_table_id TO 'user_name'@'%';
mysql> GRANT SELECT ON performance_schema.rpd_query_stats TO 'user_name'@'%';
mysql> GRANT SELECT ON performance_schema.rpd_ml_stats TO 'user_name'@'%';

Model Catalog Privileges

You need the following privileges to access machine learning models from the model catalog. 

mysql> GRANT SELECT, INSERT, CREATE, ALTER, UPDATE, DELETE, DROP, GRANT OPTION ON ML_SCHEMA_user_name.* TO 'user_name'@'%';

System Privileges

You need the following privileges for the system database where MySQL HeatWave routines reside. 

mysql> GRANT SELECT, EXECUTE ON sys.* TO 'user_name'@'%';

What's Next

MySQL Documentation Library