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:
IDENTIFIED BY 'password';