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....
How to Grant All Privileges for All Table except one
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....
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....
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
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.