CALL sys.heatwave_load - "ERROR: 1370: execute command denied to user '<user>'@'<host>' for routine 'sys.heatwave_load'"
(Doc ID 3032809.1)
Last updated on JULY 22, 2024
Applies to:
HeatWave - Version N/A to N/AInformation in this document applies to any platform.
Symptoms
When using the MySQL admin user we are able to load data into the Lakehouse engine and do what we expect.
We then created developer users, and created a developer role for those users. Those developer users get the "execute command denied to user for routine 'sys.heatwave_load'" error when trying to load data into the Lakehouse.
ERROR
-----------------------
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |