First page Back Continue Last page Image

Data Privileges can you Grant to Users?

The Following are the MySQL Data Manipulation Privileges from least powerful to most powerful

SELECT: View Data in the Database, Most Users need this to use the Database

INSERT: Needed to add data to a table, Data entry people will need this right

UPDATE: Needed to change data, Grant or not depending on how you do revisions

DELETE: Needed to remove data, this privilege should not be given to regular users

EXECUTE: Allows execution of Stored Procedure or Functions, limit access to it