PDA

View Full Version : how to limit which tables a mysql user can manipulate


electprogeny
2-26-04, 05:57 PM
I noticed that in the Ops area I can create new mysql users to my database area.

The problem I have is it appears that when I go to grant rights, that I am only able to assign rights at the database level as opposed to assigning them at the table level.

This is problematic for me because I have certain tables that I need to restrict people from accessing, but need to give them access to other tables.

Is this not possible?

HalfaBee
2-26-04, 06:26 PM
Unforunately, it is not.

The only way to stop people accessing the tables, is to not let them write php/cgi scripts.

B&T
2-26-04, 07:10 PM
Solution - pay $10 one-time fee for another database.

electprogeny
2-27-04, 10:54 PM
Oy. Thanks for the replies!