CREATE USER 'USR'@'%' IDENTIFIED BY 'x';

GRANT ALL ON *.* TO 'USR'@'%';

REVOKE UPDATE ON paymentmethods.*    FROM 'USR'@'%'; /* 0   17:39:09    REVOKE UPDATE ON paymentmethods.*    FROM 'USR'@'%' Error Code: 1141. There is no such grant defined for user 'USR' on host '%' */
GRANT  UPDATE ON paymentmethods.active TO 'USR'@'%';

/*
btw:
    SHOW GRANTS FOR 'USR'@'%'
result:
    'GRANT ALL PRIVILEGES ON *.* TO ''USR''@''%'' IDENTIFIED BY PASSWORD ''*x'''
*/