Application specific users table or mysql.users
You want a feature like Oracle Virtual Private Database. Unfortunately MySQL does not have this. There is a similar question with answers at https://stackoverflow.com/questions/5527129/mysql-how-to-do-row-level-security-like-oracles-virtual-private-database.