Simple Permissions Question

[jbh]

Hello,

I want to confirm that an administrator can offer users specific permissions based on *tables*. Is this possible?

For instance, let's say there is one database (masterdb) and with 10 users, 10 tables (one per user, such as user1, user2, etc)

If I want a user to be able to connect to my mysql server from *their domain* (I grant permission to those I trust, obviously) but only be able to use THEIR user/pass to affect ONLY THEIR table, is that possible? Such as:

GRANT SELECT,INSERT,UPDATE
ON masterdb.user1
TO user1@localhost
IDENTIFIED BY 'password';

[longneck]

yes, except that you need quotes like this: 'user1'@'localhost'

[jbh]

Outstanding. And since we'll use the mysql server instead of localhost, I will put that in accordingly.

Thank you VERY much.