How to Grant All Privileges for All Table except one
| User, date | Message |
|---|---|
|
Written by samir
4 years ago Category: General 2 posts since Thu, 05 Nov 09 |
I needed to grant all privileges to one db of all tables except fue tables where only select and insert privileges need to grant to one specific user. Please Help!!! That means i have many tables to my db['admin_bank'] with many user, myself being the admin 'admin'@'localhost' has all and grant privilege. Now how can i grant all privileges to all tables to specific user say 'samir'@'localhost' except three tables say 'aaa', 'bbb', 'ccc' with only SELECT & INSERT privileges??? Please Help ASAP.... |
|
Written by samir
4 years ago 2 posts since Thu, 05 Nov 09 |
I needed to grant all privileges to one db of all tables except fue tables where only select and insert privileges need to grant to one specific user. Please Help!!! That means i have many tables to my db['admin_bank'] with many user, myself being the admin 'admin'@'localhost' has all and grant privilege. Now how can i grant all privileges to all tables to specific user say 'samir'@'localhost' except three tables say 'aaa', 'bbb', 'ccc' with only SELECT & INSERT privileges??? Please Help ASAP.... |
|
Written by ectimo
4 years ago 9 posts since Wed, 04 Nov 09 |
This is not the real answer, but something very close to it
You need to play with REVOKE ALL PRIVILEGES since you want to leave SELECT and INSERT... REVOKE Syntax |
|
Please login to leave a reply, or register at first. |