Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata


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`;