Scott Canaan writes:
> Thank you. I found SUPER, but was trying to avoid using it as it
> gives too many privileges. I was looking for something more
> fine-grained.
Maybe you can define a stored procedure with SQL SECURITY DEFINER (and a
DEFINER with the SUPER priviledge) that sets the
Sergei,
Thank you. I found SUPER, but was trying to avoid using it as it gives too
many privileges. I was looking for something more fine-grained.
Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o:
Hi, Scott,
In MariaDB it's SUPER privilege.
Starting from 10.5 there are fine-grained privilege for various
activities, see https://mariadb.com/kb/en/grant/#global-privileges
But there is no one "system_variables_admin" privilege. Different system
variables are protected by different
We are on MariaDB 10.5.18. There is a requirement to send all syslog data to a
central syslog server. In the past, we did it using a login called ITS_READ.
It has limited privs on purpose, but used to be able to execute the SET GLOBAL
statements that we needed. Those statements are:
SET
4 matches
Mail list logo