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
posta 2 anni fa100 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande