Required Privilege in Microsoft SQL Server to Connect With Elastic Integration and Logstash JDBC Plugin

Elastic Stack Logstash
1

Hi Everyone, i would like to ask related with Microsoft SQL Integration and JDBC Plugin in logstash. as we know we need username and password to access the database with JDBC or Microsoft SQL Integration. my question would be, what privilege does the account require to access the information within the database? i have little to no experience about privilege in SQL or DB, so bear with me.

Or is there any another forum post or discussion regarding this topic?

Thanks a lot!

2

First prepare working query, then user, then test is everything working fine. You should create a login, mapped to user, assigned to database, grant select permission on those tables which will use. You will find plenty tutorials for this.
Latter you will add all that in the input JDBC plugin which is the domain of this topic.

3

Thank you for the reply and suggestions.
Yes, i already prepared the queries, the user, and access to the DB table. it's working fine now.

for Microsoft SQL Integration for Elastic Agent, the privileges are listed in metricbeat documentation.

i forgot to check each module :sweat_smile:

1 Like
4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.