By using AWS re:Post, you agree to the Terms of Use

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

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions