Minimal permissions for a MS SQL record to connect to a database

[Vasiliy Zverev]

We are going to restrict permissions for a user which is used to connect to data date because of sequrity reasons. Is there any recomendations for this?

[Dave C · Accepted solution]

Our https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2012 docs indicate to setup a dedicated user for the JIRA database, and give them the db_owner permission to that database. This is required as JIRA will create tables, sequences and other information inside of the database when plugins are installed or upgraded.

[rahuldanwade]

Hi,

As Atlassian recommends to create a dedicated user to access a jira database considering you have created separate database for JIRA.

you can a MySQL user called 'jirauser' and database called 'jiradb' and grant permissions to only jirauser to access 'jiradb'

please refer below documents.

https://confluence.atlassian.com/jira/setting-up-a-mysql-database-on-linux-for-jira-106004554.html

https://confluence.atlassian.com/jira/connecting-jira-to-mysql-185729489.html

I hope it would help!

thanks

Rahul