abdfahim Posted September 4, 2008 Share Posted September 4, 2008 I have 100 table in 10 databases. What I want is to create a user and give him access to all the tables accept one. One thing I can do is uncheck the global priviledge and give access to those 99 tables one by one. This is a lengthy process. Is there any shortcut way to block access in one table for that user?? I am using phpmyadmin to access the tables. Link to comment https://forums.phpfreaks.com/topic/122678-change-user-priviledge/ Share on other sites More sharing options...
fenway Posted September 4, 2008 Share Posted September 4, 2008 There are GRANT statements for this purpose. Link to comment https://forums.phpfreaks.com/topic/122678-change-user-priviledge/#findComment-633558 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.