Trigger Definer Already Same But User Still Denied
0
votes
1
answer
99
views
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.
i already make sure about the grants this user already full grant.
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 from server apps ?
my server apps ip 10.148.0.57
i using mariadb version 10.4
Asked by febry
(57 rep)
Nov 25, 2020, 08:02 AM
Last activity: Dec 1, 2020, 03:03 AM
Last activity: Dec 1, 2020, 03:03 AM