posted 15 years ago
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