secure one table within a database

[1andyw]

Hi,

How best can I limit access to one table within a database but not affect the remaining tables?

Thanks,

Andy

[tomws]

I think you're looking for GRANT (http://dev.mysql.com/doc/refman/5.1/en/grant.html). The specific command may look something like:
GRANT SELECT ON theDatabaseName.theTableName TO 'restrictedUsername'@'localhost';

EDIT: I should have clarified that example would apply to granting SELECT privileges for a user. The other privileges are also available.

[1andyw]

Thank you. Just what I need.:)

Andy

[meet_me224]

You can secure it using Grant...Agree with Tom...
GRANT SELECT ON theDatabaseName.theTableName TO 'restrictedUsername'@'localhost';
will do the job for you.