Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
Description
E.g. the actual used values of allow-suspicious-udfs and skip-grant-tables can't be seen in SHOW GLOBAL VARIABLES output, and are not listed in INFORMATION_SCHEMA.SYSTEM_VARIABLES either.
As both of these settings have security implications it should be possible to see their current value from the SQL level though, for audit / secure configuration check purposes.
Especially with the now added GLOBAL_VALUE_ORIGIN and GLOBAL_VALUE_PATH information in I_S SYSTEM_VARIABLES, every setting that can be done via command line or my.cnf should actually be visible in SYSTEM_VARIABLES ...?
Attachments
Issue Links
- relates to
-
MDEV-24815 Add 'allow-suspicious-udfs' and 'skip-grant-tables' to system variables
-
- Closed
-
- split to
-
MDEV-30188 Ensure all binlog* variables are visible as system variables
-
- Closed
-
-
MDEV-30189 Add and alias remaining mariadbd replication command line options as system variables
-
- Open
-
Original from
MDEV-24815. See that MDEV for options and categories of variables to exclude (plugin enable/disables/alias/deprecated ones/perf schema settings).Paraphrased from hholzgra:
debug / testing options:
Replication options
skip-grant-tables - resolved in MDEV-25419
bootstrap maybe of use.
Remaining cases that seem to be valid, and do not fit into other categories above:
allow-suspicious-udfsresolved inMDEV-24815