Detailed information on the necessary SQL permissions required for the application user

SonarQube Server / Community Build
1
  • V9.9.5
  • Windows Installer
  • detailed information on the necessary SQL permissions required for the application user.
    I hope this message finds you well ,

I am currently in the process of configuring new SQL servers and need to set the appropriate SQL permissions for each application user that connects to our MS SQL server and their respective databases. Each application in our environment has a single user account that handles the connection to the MS SQL database, and I require clarification on the specific permissions that should be granted to these user accounts.

If these permissions are already documented, could you please direct me to the appropriate resource? If not, I would greatly appreciate it if you could provide detailed information on the necessary SQL permissions required for the application user.

Thank you for your assistance in this matter. I look forward to your prompt response.

Best Regards,

Mohashin Mostafa

Leidos / Systems Engineer Integration & Configuration

mostafam@leidos.com

929-253-8007

2

As noted in the docs:

> Create an empty schema and a sonarqube user. Grant this sonarqube user permissions to create, update, and delete objects for this schema.

What makes sense for SQL Server is db_ddladmin, db_datawriter, and db_datareader