I am looking for a bit of advice/confirmation on an idea I have.
What I want to do is have on super-user who has complete global rights on a mysql installation. This I already have.
I am then going to have a couple of hundred databases in the format user.$dbname. There will be a user for each of these databases. What i want to know is if I do a GRANT ALL ON user.specificdbname TO specificdbnameuser, will that user be able to drop the database. I don't want them to be able to! I also want a secondary 'super' user who will be able to modify all those new db's with a "GRANT ALL ON user.* TO 'nearlysuperuser'". I don't want any of these other users to be able to create or drop db's just modify them. And the nearly super user to be able to modify them all but not drop or create any db's.
Does this sound like the right way to go about it?
Any help would be greatly appreciated.
------------------------------------------
Somethings come from nothing, nothing seems to come from somethings - SFA - Guerilla
roycrom
What I want to do is have on super-user who has complete global rights on a mysql installation. This I already have.
I am then going to have a couple of hundred databases in the format user.$dbname. There will be a user for each of these databases. What i want to know is if I do a GRANT ALL ON user.specificdbname TO specificdbnameuser, will that user be able to drop the database. I don't want them to be able to! I also want a secondary 'super' user who will be able to modify all those new db's with a "GRANT ALL ON user.* TO 'nearlysuperuser'". I don't want any of these other users to be able to create or drop db's just modify them. And the nearly super user to be able to modify them all but not drop or create any db's.
Does this sound like the right way to go about it?
Any help would be greatly appreciated.
------------------------------------------
Somethings come from nothing, nothing seems to come from somethings - SFA - Guerilla
roycrom