← Back to team overview

maria-discuss team mailing list archive

Thread
Date

Re: How to give user permission to create a trigger?

To: <maria-discuss@xxxxxxxxxxxxxxxxxxx>
From: "Reinis Rozitis" <r@xxxxxxx>
Date: Mon, 24 Feb 2020 14:48:35 +0200
In-reply-to: <c06b9fd3-a2ff-ab43-5fc7-08c84035ca98@plant.systems>
Thread-index: AQH8rvDoPtZsU2hcmzDFvhnAdF2OYqfcwuHA

> Is there a way to resolve this?

You should probably set the log_bin_trust_function_creators to ON. Then SUPER privilege is not required.

https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#log_bin_trust_function_creators 

rr

Follow ups

Re: How to give user permission to create a trigger?
From: Thomas Plant, 2020-02-24

References

How to give user permission to create a trigger?
From: Thomas Plant, 2020-02-24