Multiple user access to database

[jamyam]

I was going to let another friend have access to my mySQL database by creating another username/password, etc, but I don't want the user tampering with my current forum tables and such.

What is the best permissions (through ops) to grant the user so that my tables don't get altered, deleted, etc? There's no way to have him edit only the tables he creates and not be able to touch mine, is there?

Thanks!

[B&T]

If you want him to only have access to some tables then you need to pay $10 for a second data base. The permissions you set up for users are access permissions - not table specific. So if he can insert - he can insert.

[jamyam]

Hm...ok, thanks for the help!