How to prevent a user from dropping tables

[Gilbert johnson]

Hello fellow ranchers

I need some information on how to grant/revoke privileges on mysql database.

Basically I want to create a user and grant him select,insert and update permissions on the database. This is the user with which I'm connecting from my web app to perform operations.

So I connect as root and create the database discountweb - then I'm using the following command

GRANT SELECT, INSERT, UPDATE ON discountweb.* TO 'discountweb'@'localhost' IDENTIFIED BY 'test123' WITH GRANT OPTION;

This works fine - but this user (discountweb) also has the option to drop any table.

Can anyone let me know - how to revoke the drop privilege for this user.

Thanks

[Gilbert johnson]

And also this user is able to drop the whole database.

So he should not be able to drop tables or database.

Thanks

[Campbell Ritchie]

REVOKE drop_database FROM user ON my_database; ?

Not sure of the exact syntax, but it will be something like that.
If that doesn't work, go through your database instructions and look for revoke.