Invoke Lambda Privilege MySQL issue

0

Hi guys,

I have an Aurora v3 cluster, with MySQL, which has an INSERT Trigger. When the data are inserted the trigger fires a Lambda.

If I write within the table using the admin user of the DB everything works fine, but if I try to use another user the following message appears:

Unknown trigger has an error in its body: 'Access denied; you need (at least one of) the Invoke Lambda privilege(s) for this operation'

I can't figure out what I am missing. I've already set log_bin_trust_function_creators=1 and these are the GRANTS associated with the user:

GRANT USAGE ON *.* TO `pippo`@`%

GRANT ALL PRIVILEGES ON `prod`.* TO `pippo`@`%

GRANT `AWS_LAMBDA_ACCESS`@`%`,`rds_superuser_role`@`%` TO `pippo`@`%

Thanks for help

Mirco
demandé il y a 2 ans100 vues
Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions