distal-attribute
distal-attribute
distal-attribute
distal-attribute

How to Grant All Privileges for All Table except one

User, date Message
Written by samir
5 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
5 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
5 years ago
9 posts since Wed, 04 Nov 09
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.