[WebLogic] DBMS Authentication Provider 설정

Domain > Security Realms > myrealms > Providers > Authentication
New

Common
  Name: OracleAuthentication
  Description: Provider that performs DBMS authentication
  Control Flag: SUFFICIENT

Provider Specific
  Plaintext Passwords Enabled: Checked
  Data Source Name: CSDS
  Group Membership Searching: Unlimited
  Max Group Membership Search Level: 0
  SQL Get Users Password: SELECT PASSWORD FROM HKMC_USER_INFO WHERE USER_ID = ?
  SQL User Exists: SELECT USER_ID FROM HKMC_USER_INFO WHERE USER_ID = ?
  SQL List Users: SELECT USER_ID FROM HKMC_USER_INFO WHERE USER_ID LIKE ?
  SQL List Groups: SELECT DEPT_NAME FROM HKMC_DEPT_INFO WHERE DEPT_NAME LIKE ?
  SQL Group Exists: SELECT DEPT_NAME FROM HKMC_DEPT_INFO WHERE DEPT_NAME = ?
  SQL Is Member: SELECT USER_ID FROM HKMC_USER_INFO WHERE DEPT_NAME = ? AND USER_ID = ?
  SQL List Member Groups: SELECT DEPT_NAME FROM HKMC_USER_INFO WHERE USER_ID = ?
  Descriptions Supported: Unchecked
  SQL Get User Description: SELECT U_DESCRIPTION FROM USERS WHERE U_NAME = ?
  SQL Get Group Description: SELECT G_DESCRIPTION FROM GROUPS WHERE G_NAME = ?

---

CREATE TABLE UCM_OCS.HKMC_USER_INFO
(
USER_ID                VARCHAR2 (10) NOT NULL,
USER_NAME              VARCHAR2 (50) NOT NULL,
USER_NAME_ENG          VARCHAR2 (100),
DEPT_CODE              VARCHAR2 (10) NOT NULL,
DEPT_NAME              VARCHAR2 (100),
DUTY_CODE              VARCHAR2 (4),
DUTY_NAME              VARCHAR2 (50),
POS_CODE               VARCHAR2 (4),
POS_NAME               VARCHAR2 (50),
POS_LEVEL_CODE         VARCHAR2 (4),
POS_LEVEL_NAME         VARCHAR2 (50),
JOB_CODE               VARCHAR2 (10),
JOB_NAME               VARCHAR2 (50),
EMAIL                  VARCHAR2 (100),
USER_CLASSI_CODE       VARCHAR2 (4),
USER_CLASSI_NAME       VARCHAR2 (50),
LOCATION_CODE          VARCHAR2 (10),
LOCATION_NAME          VARCHAR2 (20),
ADD_DEPT_INFO          VARCHAR2 (1),
ADD_DEPT_ASSIGN_DATE   DATE,
DUP_DEPT_INFO          VARCHAR2 (1),
DUP_DEPT_ASSIGN_DATE   DATE,
INTEGRATED_YN          VARCHAR2 (10),
GIVE_EXCP_YN           VARCHAR2 (1),
WORK_YN                VARCHAR2 (1),
INDUS_ACCI_YN          VARCHAR2 (1),
JO_CODE                VARCHAR2 (10),
BAN_CODE               VARCHAR2 (10),
GWA_CODE               VARCHAR2 (10),
TEAM_CODE              VARCHAR2 (10),
GROUP_CODE             VARCHAR2 (10),
DIVISION_CODE          VARCHAR2 (10),
HDQ_CODE               VARCHAR2 (10),
CEO_CODE               VARCHAR2 (10),
VICE_PRESIDENT_CODE    VARCHAR2 (10),
UPDATE_DATE            DATE,
USER_CREATE_DATE       DATE,
USER_RETIRE_DATE       DATE,
DEPT_ASSIGN_DATE       DATE,
DEPT_ORDER_DATE        DATE,
DOC_MANAGER            VARCHAR2 (5),
UUSER_GUBUN            VARCHAR2 (2),
UUSER_MOBILE           VARCHAR2 (2),
STATUS                 VARCHAR2 (1),
MOBILE                 VARCHAR2 (50),
PASSWORD               VARCHAR2 (80),
ENGLISH_NAME           VARCHAR2 (50),
USER_CLASS             VARCHAR2 (20),
DEPT_NAME_ENG          VARCHAR2 (50),
DUTY_NAME_ENG          VARCHAR2 (50),
POS_NAME_ENG           VARCHAR2 (50),
LOCATION_NAME_ENG      VARCHAR2 (50),
USER_CLASSI_NAME_ENG   VARCHAR2 (50),
ULOCALE                VARCHAR2 (2),
UPAGESIZE              VARCHAR2 (10),
PROJECT_YN             CHAR (1) DEFAULT 'N',
SWORKDI                VARCHAR2 (1) DEFAULT 'N',
SWORKDATE              DATE DEFAULT NULL,
HKMC_ROLE_CODE         VARCHAR2 (10) DEFAULT '10000',
OUTLOOK_USE_YN         VARCHAR2 (2) DEFAULT 'N',
STG_CTL_GUBUN          VARCHAR2 (2) DEFAULT '1',
VIRTUAL_SPACE_YN       VARCHAR2 (1) DEFAULT 'N'
);

CREATE TABLE UCM_OCS.HKMC_DEPT_INFO
(
DEPT_CODE              VARCHAR2 (10) NOT NULL,
DEPT_NAME              VARCHAR2 (75),
DEPT_CODE_OLD          VARCHAR2 (10),
UPPER_DEPT_CODE        VARCHAR2 (10),
UPPER_DEPT_CODE_OLD    VARCHAR2 (10),
ORG_RANK_ORDER         VARCHAR2 (4),
ORG_PRT_ORDER          VARCHAR2 (4),
MGR_DUTY_CODE          VARCHAR2 (20),
MGR_DUTY_NAME          VARCHAR2 (50),
MANAGER_ID             VARCHAR2 (10),
MANAGER_NAME           VARCHAR2 (50),
LOCATION_CODE          VARCHAR2 (10),
LOCATION_NAME          VARCHAR2 (30),
USER_CLASSI_CODE       VARCHAR2 (4),
USER_CLASSI_NAME       VARCHAR2 (50),
INTEGRATED_YN          VARCHAR2 (1),
STATUS                 VARCHAR2 (1),
DEPT_CREATE_DATE       DATE,
DEPT_RETIRE_DATE       DATE,
DEPT_ORDER_DATE        DATE,
DEPT_CHANGE_REASON     VARCHAR2 (2000),
SUB_DEPT_INFO          VARCHAR2 (1),
DEPT_NAME_ENG          VARCHAR2 (100),
MANAGER_NAME_ENG       VARCHAR2 (50),
USER_CLASSI_NAME_ENG   VARCHAR2 (50),
DEPT_CODE_NEW          VARCHAR2 (10),
UPPER_DEPT_CODE_NEW    VARCHAR2 (10),
ORG_GRADE_CODE         VARCHAR2 (20),
ORG_GRADE_NAME         VARCHAR2 (50)
);