I created a user with drop privilege to a database.
How can I create a user who has the privilege to drop tables of a specified database, but not database.
Do GRANT DROP ON TABLE thedatabase.* TO user1.
The MySQL Reference Manual is a great place to look for this kinds of things.
GRANT DROP ON TABLE thedatabase.* TO user1
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
2 years ago