Allowing only specific tables in mySQL

[ferhan]

Summary of problem: I am creating a question game in Flash (forget flash in this discussion), and I need users to be able to access only their specific tables. Different users can populate their own tables with data, but I want users, to be able to access only their own table. Is there anything special I need to do?

I want it in a way, that the user can select which tables they would like to view and edit.

I may not be clear here, or my question is too simple?

Ferhan

[Anon]

Yes, you can take a look here:

http://www.mysql.com/doc/manual.php?search_query=privileges&depth=0

You must define entries in your mysql database, table user, allowing one or other some privileges.

fLIPIS