Grants for users - not admins
Hey all -
I'm setting up a development box for my programmers. Each user will have their own username/pwd with certain restrictions.
When I look at the manual for GRANTS and REVOKEs it tells me that DROP refers to tables. BUT my test user was able to create a database, drop that database and then drop an existing database. I'm ok with the user creating and dropping their own databases --- just not someone elses!
When I remove the DROP privilige the user can no longer drop databases, not even the one they created. BUT they also can NOT DROP TABLES. yikes. That's not good. How do I allow the user to drop tables but not databases.
MySQL ver 4.1.7 on Linux
thanks,
erin
Subject
Views
Written By
Posted
Grants for users - not admins
3305
August 25, 2005 02:55PM
2161
August 25, 2005 04:43PM
2044
August 25, 2005 10:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.