GRANT SELECT on *.* to readonly@'%' identified by 'readonly';
This will create the user readonly, create the host '%', set the password, and who knows what else.
You know, mysql documentation usually refers to the host, network, and user permissions as the "big three". Your "big three" are all inside the user level permissions.
2-cents.
bbaker
Hey everybody --
I'm trying to get a handle on permissions in MySQL. I've read the manual several times, and I still lack the 'big picture'.
It seems to me there are three levels of security:
1. Database permissions
2. Table permissions
3. column permissions.
What I don't understand is how all three interact. For instance, if you want to give a user 'update' rights to a particular column, what db and table permissions must they have?
TIA!
Steve Lefevre
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
