mirror of
https://github.com/MariaDB/server.git
synced 2026-01-29 14:59:08 +01:00
16b5bf03d7
According to SQL standard, rows from `INFORMATION_SCHEMA.TRIGGERS` table should be visible to users with non-SELECT privileges on the columns. `ACTION_CONDITION`, `ACTION_STATEMENT` and `DEFINER` columns should be visible only if the user is the owner of the schema. MariaDB uses `TRIGGER` privilege instead of owner, which controls the visibilty of all columns, including those which only need non-SELECT privileges. This fix - Allows users with non-SELECT privileges- INSERT, DELETE or UPDATE, to see rows in `INFORMATION_SCHEMA.TRIGGERS` table. - Ensure `ACTION_CONDITION`, `ACTION_STATEMENT` and `DEFINER` columns are `NULL` unless the user is the owner of the schema or has `TRIGGER` privilege. |
||
|---|---|---|
| .. | ||
| trig_frkey.inc | ||
| trig_frkey2.inc | ||
| triggers_03.inc | ||
| triggers_03e_columns.inc | ||
| triggers_03e_db_level.inc | ||
| triggers_03e_db_table_mix.inc | ||
| triggers_03e_definer.inc | ||
| triggers_03e_global_db_mix.inc | ||
| triggers_03e_prepare.inc | ||
| triggers_03e_table_level.inc | ||
| triggers_03e_transaction.inc | ||
| triggers_08.inc | ||
| triggers_09.inc | ||
| triggers_0102.inc | ||
| triggers_0407.inc | ||
| triggers_1011ext.inc | ||