[MDEV-30702] Feature request: more fine graind trigger privileges Created: 2023-02-21 Updated: 2023-02-21 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Triggers |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Hartmut Holzgraefe | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Right now there is only the TRIGGER privilege, which is needed to create, change or drop triggers, but also to see the trigger definition with SHOW CREATE TRIGGER or via INFORMATION_SCHEMA tables. With other database objects we have separate privileges for modifying and viewing, so splitting the TRIGGER privilege in eg. SHOW TRIGGER and CREATE TRIGGER might make sense, too. |