Atlassian 제품 별 Oracle DB 설정 정보

Server 또는 DataCenter appl 군 대상 Oracle 설정 정보입니다.

Ref

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

Twoseed 공개 자료