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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.