4.3.3 MySQL HeatWave Lakehouse Privileges

Review the following privileges required to use MySQL HeatWave Lakehouse.

Before You Begin

• Review Additional MySQL HeatWave Lakehouse Requirements.

DB System Privileges

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.

The PROCESS privilege on the appropriate database in the DB System to access information about threads running within the server.

mysql> GRANT PROCESS ON database_name.* TO 'user_name'@'%';

The EXECUTE privilege on the sys schema to access statements that execute stored routines.

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

The SELECT privilege to access external Lakehouse tables and track/monitor the status of routines.

mysql> GRANT SELECT ON performance_schema.* TO 'user_name'@'%';

The EXPORT_QUERY_RESULTS privilege to Export Query Results to Object Storage (Available as of MySQL 9.1.1-u1).

mysql>GRANT EXPORT_QUERY_RESULTS ON database_name.* TO 'user_name'@'%';

Object Storage Privileges

To access object storage resources and files to load data, you require specific privileges. See the following to learn more:

• PAR Privileges

• Resource Principal Privileges

Privileges to Export Query Results

To export query results to object storage (as of MySQL 9.1.1-u1), you require the appropriate resource principals privileges in addition to the appropriate DB System Privileges. See Resource Principal Privileges to review how to set them up.

MySQL HeatWave on AWS Privileges

For MySQL HeatWave on AWS, you require the appropriate privileges to access S3 resources. To learn more, see Manage AWS Access and Creating Lakehouse Mapping from the MySQL HeatWave on AWS Service Guide.

What's Next

• Review Supported File Formats.