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';