Hello all,
I am working on a project that will have multiple users, each user will have their own database. However, the tables inside of each individual database will have the same name as they will contain the same schema and presumably the same type of data.
My problem, if I create a user and grant table level privileges on tables X, Y, and Z then the newly created user would have access to all tables with that name. If they were to gain access to another users database then they could, in theory, access the other data.
Is this correct, or do I misunderstand the privelige scheme.
Maybe someone can steer me in the right direction if this is not the best solution.
TIA
John
I am working on a project that will have multiple users, each user will have their own database. However, the tables inside of each individual database will have the same name as they will contain the same schema and presumably the same type of data.
My problem, if I create a user and grant table level privileges on tables X, Y, and Z then the newly created user would have access to all tables with that name. If they were to gain access to another users database then they could, in theory, access the other data.
Is this correct, or do I misunderstand the privelige scheme.
Maybe someone can steer me in the right direction if this is not the best solution.
TIA
John