/
Atlassian 제품 별 Oracle DB 설정 정보
Atlassian 제품 별 Oracle DB 설정 정보
- 모성완 (Unlicensed)
Owned by 모성완 (Unlicensed)
2021-01-29
2 min read
Loading data...
Server 또는 DataCenter appl 군 대상 Oracle 설정 정보입니다.
Ref
Confluence : https://confluence.atlassian.com/doc/database-setup-for-oracle-173821.html
Bamboo : https://confluence.atlassian.com/bamboo/oracle-289276820.html
Bitbucket : https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-oracle-776640379.html
Crowd : https://confluence.atlassian.com/crowd/oracle-32243789.html
- 1 Confluence
- 2 Jira
- 3 Bamboo
- 4 Bitbucket
- 5 Crowd
Confluence | CREATE USER <user>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_name>
QUOTA UNLIMITED ON <tablespace_name>;
GRANT CONNECT TO <user>;
GRANT RESOURCE TO <user>;
GRANT CREATE TABLE TO <user>;
GRANT CREATE SEQUENCE TO <user>;
GRANT CREATE TRIGGER TO <user>;
----------------------- [예제] -----------------------
CREATE USER wiki-user IDENTIFIED BY <사용자 정의 패스워드> DEFAULT TABLESPACE tb_wiki QUOTA UNLIMITED ON tb_wiki;
GRANT CONNECT TO wiki-user;
GRANT RESOURCE TO wiki-user;
GRANT CREATE TABLE TO wiki-user;
GRANT CREATE SEQUENCE TO wiki-user;
GRANT CREATE TRIGGER TO wiki-user; |
Jira | CREATE USER <user>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_name>
QUOTA UNLIMITED ON <tablespace_name>;
GRANT CONNECT TO <user>;
GRANT CREATE TABLE TO <user>;
GRANT CREATE SEQUENCE TO <user>;
GRANT CREATE TRIGGER TO <user>;
----------------------- [예제] -----------------------
CREATE USER jira-user IDENTIFIED BY <사용자 정의 패스워드> DEFAULT TABLESPACE tb_jira QUOTA UNLIMITED ON tb_jira;
GRANT CONNECT TO jira-user;
GRANT CREATE TABLE TO jira-user;
GRANT CREATE SEQUENCE TO jira-user;
GRANT CREATE TRIGGER TO jira-user; |
Bamboo | CREATE USER <user> IDENTIFIED BY <password>;
GRANT CONNECT, RESOURCE, CREATE TABLE TO <user>;
----------------------- [예제] -----------------------
CREATE USER bamboo-user IDENTIFIED BY <사용자 정의 패스워드>;
GRANT CONNECT, RESOURCE, CREATE TABLE TO bamboo-user; |
Bitbucket | |
Crowd |