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