In MySQL, how do you allow another user to create other users? In turn, those users should only be able to view some tables.
From MySQL's privileges documentation, the
For other privileges, read MySQL's
Note, I've linked to MySQL 5.0 documentation.
I think the answer is this:
Plus setting grant access on the relevant tables.