I need to grant privileges to all users, I can do:
GRANT select on table TO user1;
GRANT select on table TO user2;
...
But there are many users. How can I grant this privilege to all users at once?
I tried:
GRANT select on table TO ALL;
But that doesn't work.