List of keywords used in data access


#1

As part of a larger data centre migration project I have been given the task of setting up Piwik on a new server. For security reasons only keywords requested directly from the database admin will be available to the user account used by Piwik to write to the database.

From an initial review of the Piwik source code it seems to just use standard keywords like SELECT, INSERT, UPDATE, CREATE. If someone could confirm that this is correct and there are no other keywords in use that would be great.


#2

It seems the list of keywords is documented here in the requirements.

The MySQL USER should have the permission to SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES.