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. Link to comment https://forums.phpfreaks.com/topic/229556-user-can-create-databases-but-not-drop-for-prefix_/ Share on other sites More sharing options...
fenway Posted March 5, 2011 Share Posted March 5, 2011 Did you explicit grant the drop privilege? Link to comment https://forums.phpfreaks.com/topic/229556-user-can-create-databases-but-not-drop-for-prefix_/#findComment-1183245 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] Link to comment https://forums.phpfreaks.com/topic/229556-user-can-create-databases-but-not-drop-for-prefix_/#findComment-1183899 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. Link to comment https://forums.phpfreaks.com/topic/229556-user-can-create-databases-but-not-drop-for-prefix_/#findComment-1184033 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). Link to comment https://forums.phpfreaks.com/topic/229556-user-can-create-databases-but-not-drop-for-prefix_/#findComment-1184373 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.