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?
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.
db_owner
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
It looks like you're new here. Sign in or register to get started.
