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

Trigger Definer Already Same But User Still Denied

    XMLWordPrintable

Details

    Description

      currently I already have user like this 'app_user'@'10.148.0.0/255.255.240.0' and I have the trigger with definer like this

      CREATE DEFINER=`app_user`@`10.148.0.0/255.255.240.0` TRIGGER usertable_delete_audit

      but when apps insert data i got this error

      trigger command denied to user 'app_user'@'10.148.0.0/255.255.240.0' for table user table.

      and i tried create or replace the trigger using user app_user i got error message 

      Access denied; you need (at least one of) the SUPER privileges for this operation

      this is grant for user app_user

      GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON

      this impact from user with specific host ? i mean because the user have grant like this 10.148.0.0/255.255.240.0. And the trigger only can give the access from specific ip

      Attachments

        Activity

          People

            Unassigned Unassigned
            febridev febriyant
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.