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.
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.
I hope it would help!
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events