MySQL Forums
Forum List  »  Security

restricting privileges on tables
Posted by: Michael Aldrich
Date: May 12, 2016 05:56AM

We have several applications on a database accessed by the same functional user. We are decommissioning one but we want to limit access to read only. Modifying the code is not possible but it was suggested that removing update/insert/delete privilege on the underlying tables for this application might be sufficient.

That's where we need help. The functional user has full privileges on all tables in the database. Is there an easy way to remove insert/update/delete only on those tables. Here is the access privileges for the user:

GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD 'XXX';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON `database`.* TO 'user'@'%';

mike aldrich
washtenaw community college
maldrich@wccnet.edu

Options: ReplyQuote


Subject
Views
Written By
Posted
restricting privileges on tables
1527
May 12, 2016 05:56AM


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.