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
gefragt vor 2 Jahren100 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen