Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2015

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?

2 answers

1 accepted

0 votes
Answer accepted
Dave C
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 21, 2015

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.

0 votes
rahuldanwade
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2015

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

 

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

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
AUG Leaders

Upcoming Jira Events