How to Grant All Privileges for All Table except one

[expired user #4459]'s profile image [expired user #4459] posted 14 years ago in General Permalink
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....
[expired user #4459]'s profile image [expired user #4459] posted 14 years ago Permalink
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....
[expired user #4456]'s profile image [expired user #4456] posted 14 years ago Permalink
This is not the real answer, but something very close to it

grant all on *.* to 'samir'@'%';
REVOKE ALL PRIVILEGES on *.aaa FROM 'samir'@'%';
REVOKE ALL PRIVILEGES on *.bbb FROM 'samir'@'%';
REVOKE ALL PRIVILEGES on *.ccc FROM 'samir'@'%';


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.