Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

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

Vasiliy Zverev
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.
Get recognized
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?

Answer
Watch
Like Consulente Atlassian likes this
1539 views

2 answers

1 accepted

0 votes
Answer accepted
Dave C
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.

Reply
0 votes
rahuldanwade
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.
Get recognized
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

 

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events