Articles Related
Granting PRIVILEGES
The ALL PRIVILEGES grants every system privilege to a user. If you want a user to have most of the system privileges, you can grant ALL PRIVILEGES to a user and then revoke only those system privileges that you do not want them to have.
GRANT ALL PRIVILEGES TO UserName;
REVOKE ADMIN, CACHE_MANAGER FROM UserName;