Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37474

Privilege check of information_schema.TRIGGERS does not correspond the standard

    XMLWordPrintable

Details

    • Q4/2025 Server Maintenance

    Description

      According the standard row with the trigger info showed if user has column privileges other than SELECT. We have following column privileges :

      • INSERT
      • REFERENCES (unused)
      • SELECT
      • UPDATE
        To have all operation which has influence on a trigger we have to add DELETE and remove REFERENCES, i.e. in our case if user has:
      • DELETE
      • INSERT
      • UPDATE

      Even if the user can see a row in the INFORMATION_SCHEMA.TRIGGERS, a user will only see NULL for ACTION_CONDITION and ACTION_STATEMENT, unless he's the owner of the schema. We do not have owners but use TRIGGER privilege instead. Now it control whole row appearance but should control only content of that two columns.

      Attachments

        Issue Links

          Activity

            People

              raghunandan.bhat Raghunandan Bhat
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.