I'm just curious as to why a new user, created with the User Manager tool, includes ALTER as a privilege, but not insert or update? It seems that either a default user should either have a range of useful write tools, or none at all.
Why does a new user allow ALTER by default?
That's true and also weird because the first time I tried it, I had all the view items plus ALTER generated in the code. I copied dowm:
CREATE USER 'Jason'@'localhost' IDENTIFIED BY '4OmIzI'; GRANT ALTER, SHOW VIEW, SHOW DATABASES, SELECT, PROCESS, EXECUTE ON . TO 'Jason'@'localhost';
FLUSH PRIVILEGES;
Please login to leave a reply, or register at first.