When you execute GRANT ALL PRIVILEGES ON *.* TO 'sail'@'%';, it grants the 'sail' user extensive permissions, including the ability to manage databases and create users.
However, this does not enable the 'sail' user to delegate database access permissions to another user, leading to permission errors while using package as newly created user will not have access to newly created database.
For this, WITH GRANT OPTION should be added to sail user.
When you execute
GRANT ALL PRIVILEGES ON *.* TO 'sail'@'%';, it grants the 'sail' user extensive permissions, including the ability to manage databases and create users.However, this does not enable the 'sail' user to delegate database access permissions to another user, leading to permission errors while using package as newly created user will not have access to newly created database.
For this,
WITH GRANT OPTIONshould be added to sail user.