Hi @AnuragSharma-MSFT , sorry to write it as an answer but I cannot submit my comment ('Submit' button not working)
Yes sure, let me elaborate on my issue, might be useful for the community:
In our application we use sql triggers. Everything went fine as long as the log_bin were OFF, as in all of our previous servers. Now, with the log_bin ON, we get this message when a trigger gets activated:
You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
We did set to ON the suggested variable log_bin_trust_function_creators to test as a workaround and it works, but this is NOT safe because it might have unintended consequences as explained in MariaDB's documentation, so using this variable is not an option
For security, we certainly cannot give SUPER privileges to the user either.
The problem is: being able to continue to execute our triggers, without enabling unsafe features.
Thanks,
Luis