What MySQL privileges are required to use Table Grid Editor

There are 2 points regarding this question

• If the user is using jira as datasource, i.e

  gd.ds=jira

  or

  col.<column name>.query.ds=jira

  there is no need to worry about permissions because jira is providing the plugin with the connection and the plugin doesn't need neither username nor password

• If some other mysql datasource is configured, for example

  gd.columns=alist col.alist=list col.alist.type=list col.alist.query=select plane_name from test_data col.alist.query.ds=gridds datasource.names=gridds ds.gridds.connection.type=mysql ds.gridds.connection.url=jdbc:mysql://localhost:3306/igrid_test?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=false ds.gridds.connection.username=igrid_tester ds.gridds.connection.password=igrid_tester

  Then the user has to be sure that there is a user igrid_tester at localhost identified by password 'igrid_tester' and that this 'igrid_tester' user has following privileges on all tables of the schema which is used (igrid_test in our case):

  • CREATE

  • DROP

  • ALTER

  • SELECT

  • INSERT

  • UPDATE

  • DELETE

  • INDEX

     

Here is how you can create and setup privileges for such a user in mysql: