Results 1 to 2 of 2
Thread: MySQL - Table Level Permissions
May 28, 2009, 22:50 #1
MySQL - Table Level Permissions
I have a MySQL 5.x database. I have 5 tables in it. Is there anyway I can have 5 users assigned to 5 different tables in such a way that one user can have access to the DB but can ONLY view his own table and not view any other tables in that DB?
May 29, 2009, 00:31 #2
- Join Date
- Aug 2000
- Philadephia, PA
- 1 Post(s)
- 0 Thread(s)
Yes, see the manual, scroll to "Table Privileges"
Don't grant access to the database, only to the tableTry Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more