Web Hosting Talk







View Full Version : MySQL table permissions


SPaReK
05-16-2002, 11:50 AM
Is there a way to grant permissions to a specific table in a MySQL database? Is there a way for a specific user to do this (i.e. not root)? I have a client that is wanting a user to have access to a specific table in his database, but only that database. I can enable access to the entire database, but don't know how to prevent access to just that one table. Is there a way that he can do this, without using the 'mysql' database?

Thanks