What MySQL privileges are required to use Table Grid Editor



What are the privileges required for the table grid when connecting to a mysql database ?

 

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:

 

CREATE USER `igrid_tester`@`localhost`; SET PASSWORD FOR `igrid_tester`@`localhost` = PASSWORD('igrid_tester'); GRANT CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE, INDEX ON `igrid_test`.* TO `igrid_tester`@`localhost`;