MySQL Forums
Forum List  »  Security

Re: Grants for users - not admins
Posted by: Harrison Fisk
Date: August 25, 2005 04:43PM

The DROP grant will do different things on different levels.

If you GRANT the DROP privilege on a single database, they can only drop the tables in the database or the database itself.

If you give the global DROP (ON *.*), then they can do databases or tables.

The first one should do what you want. For example:

GRANT DROP ON db.* TO user@host;

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3306
August 25, 2005 02:55PM
Re: Grants for users - not admins
2161
August 25, 2005 04:43PM
2045
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.