Grant Permission Not working

Databases
1

Im trying to only grant INSERT commands to a user, for a specific databse.
The commands run ok, but when i try a run a delete statment it works fine, and it shoulnt.

DB NAME rb_emails

GRANT SELECT ON rb_emails.* TO ‘rb_user’@‘%’
Ive even tried @‘localhost’ also

FLUSH PRIVILEGES;
select * from mysql.user where User=‘rb_user’

I’ve even tried to revoke all access
REVOKE ALL PRIVILEGES ON . FROM ‘rb_user’@‘%’;
REVOKE GRANT OPTION ON . FROM ‘rb_user’@‘%’;
FLUSH PRIVILEGES;
SHOW GRANTS FOR ‘rb_user’@‘%’

  • THIS DOES NOT WORK STILL SHOWS HE HAS FULL RIGHTS

When i look at his account everything is set to ‘N’ but i can still run a delete command any ideas?

2

do you have any other hosts defined for that user?
select User, Host from mysql.user where User = ‘rb_user’;

what does his account say when he logs in, and runs
SHOW GRANTS FOR CURRENT_USER();