Vebut Posted March 4, 2011 Share Posted March 4, 2011 I’ve setup all privileges for a database user on prefix\_%. This user can create databases and tables for the prefix but not drop databases. I’ve tried to fix this but unless I grant global privileges for this user the DROP command is unavailable. As I grant the global drop privilege all databases (global) become visible for this user (as it should I guess), but I need this user to be able to drop databases for the specific prefix and not be able to touch/see the other databases. User harry Database prefix\_%, Grant No, Privileges All Privileges, Table specific privileges No. Still this user can create databases, but not drop. Why? I’m sure I’ve missed something as the other users do not have this problem. Quote Link to comment Share on other sites More sharing options...
fenway Posted March 5, 2011 Share Posted March 5, 2011 Did you explicit grant the drop privilege? Quote Link to comment Share on other sites More sharing options...
Vebut Posted March 7, 2011 Author Share Posted March 7, 2011 How would I do that? My usual process is to use PHPMyAdmin to create users with all privileges on their prefix. I've attached some screenshots to show my current setup for a new user "demo", that also has the same problem. [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
fenway Posted March 7, 2011 Share Posted March 7, 2011 ALL PRIVILEGES is usually a bad idea -- public users don't need alter, drop, etc. Quote Link to comment Share on other sites More sharing options...
Vebut Posted March 8, 2011 Author Share Posted March 8, 2011 These users are system administrators. So they require it, but I need them to be able to drop databases for their sections (prefix). Quote Link to comment 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.