toprashantjha Posted January 2, 2012 Share Posted January 2, 2012 Hi, I have given all the permission to a user say 'prashant' on one of the DB say 'db1'. I need to restrict the user to access some tables on db1. I am using MySql Version - 5.1.50 Please suggest. Quote Link to comment https://forums.phpfreaks.com/topic/254191-grant-permission/ Share on other sites More sharing options...
fenway Posted January 2, 2012 Share Posted January 2, 2012 GRANT .... ON db1.yourTable TO 'prashant'@'localhost'; Quote Link to comment https://forums.phpfreaks.com/topic/254191-grant-permission/#findComment-1303326 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.