[
https://issues.apache.org/jira/browse/NIFI-8378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17366759#comment-17366759
]
Matt Burgess commented on NIFI-8378:
------------------------------------
PutDatabaseRecord doesn't perform any SELECT statements per se, but the driver
might be translating calls to get the table metadata into a SELECT under the
hood. If the problem is that it is trying to select from a different database /
catalog / schema, make sure you populate the Catalog Name and/or Schema Name
properties so it will only try to access the correct db/cat/schema.
> PutDatabaseRecord / MySQL does not allow predefined queries
> -----------------------------------------------------------
>
> Key: NIFI-8378
> URL: https://issues.apache.org/jira/browse/NIFI-8378
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: DEOM Damien
> Priority: Minor
> Attachments: image-2021-03-29-20-05-13-207.png,
> image-2021-03-29-20-05-35-615.png
>
>
>
> PutDatabaseRecord and MySQL seems to make 'meta' queries outside the
> specified database if the statement type is predefined.
> These queries are not allowed on non admin sql users. The pb is that it is
> not obious to track tem. I get this error message:
> {quote}
> PutDatabaseRecord[id=6fd1383b-aab8-194b-8622-babb62ae1376] Failed to process
> StandardFlowFileRecord[uuid=a6ca67dd-a921-4714-84d0-0dbf2c1f40dd,claim=StandardContentClaim
> [resourceClaim=StandardResourceClaim[id=1617036481159-111,
> container=default, section=111], offset=300938,
> length=417],offset=0,name=a6ca67dd-a921-4714-84d0-0dbf2c1f40dd,size=417] due
> to java.sql.SQLSyntaxErrorException: SELECT command denied to user
> 'pda-user-int'@'192.168.50.6' for table 'channel':
> {quote}
>
> Could you explain what queries are done ?
> Thx
> Here is my configuration:
>
> !image-2021-03-29-20-05-13-207.png!
> MySQL user:
> !image-2021-03-29-20-05-35-615.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
