TEST1 로그인건
- 작성자 :
- 유*만
- 작성일 :
- 2009-07-02 00:00:00
- 조회수 :
- 5,919
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
1) TEST1로그인 건
'ENT' -> 'USR' 으로 수정하니까 로그인은 되네요.
ERD 분석을 해보지 않아서?
답변 부탁드려요?
drop view COMVNUSERMASTER;
CREATE OR REPLACE FORCE VIEW COMVNUSERMASTER
(UNIQ_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID,USER_SE,ORGNZT_ID)
AS
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES, GROUP_ID,USER_SE,ORGNZT_ID
FROM (
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,'' GROUP_ID,'GNR' AS USER_SE, '' AS ORGNZT_ID
FROM COMTNGNRLMBER
UNION ALL
SELECT
UNIQ_ID,EMPLYR_ID,PASSWORD,EMPLYR_NM,ZIP,HOMEADRES,EMAIL_ADRES,GROUP_ID,'USR' AS USER_SE, ORGNZT_ID
FROM COMTNEMPLYRINFO
UNION ALL
SELECT UNIQ_ID,ENTRPRSMBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,'','USR' AS USER_SE, '' AS
ORGNZT_ID
FROM COMTNENTRPRSMBER
)
ORDER BY UNIQ_ID;
'ENT' -> 'USR' 으로 수정하니까 로그인은 되네요.
ERD 분석을 해보지 않아서?
답변 부탁드려요?
drop view COMVNUSERMASTER;
CREATE OR REPLACE FORCE VIEW COMVNUSERMASTER
(UNIQ_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID,USER_SE,ORGNZT_ID)
AS
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES, GROUP_ID,USER_SE,ORGNZT_ID
FROM (
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,'' GROUP_ID,'GNR' AS USER_SE, '' AS ORGNZT_ID
FROM COMTNGNRLMBER
UNION ALL
SELECT
UNIQ_ID,EMPLYR_ID,PASSWORD,EMPLYR_NM,ZIP,HOMEADRES,EMAIL_ADRES,GROUP_ID,'USR' AS USER_SE, ORGNZT_ID
FROM COMTNEMPLYRINFO
UNION ALL
SELECT UNIQ_ID,ENTRPRSMBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,'','USR' AS USER_SE, '' AS
ORGNZT_ID
FROM COMTNENTRPRSMBER
)
ORDER BY UNIQ_ID;
A
안녕하세요..
말씀해 주신 부분을 확인해 보니깐..
View 생성 상에 사용자 구분 정보인 ENT와 USR이 서로 바뀌었습니다.
다음의 view 생성문을 다시 실행 시켜 주십시오..
-----------------------------
CREATE OR REPLACE FORCE VIEW COMVNUSERMASTER
(UNIQ_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID,USER_SE,ORGNZT_ID)
AS
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES, GROUP_ID,USER_SE,ORGNZT_ID
FROM (
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,'' GROUP_ID,'GNR' AS USER_SE, '' AS ORGNZT_ID
FROM COMTNGNRLMBER
UNION ALL
SELECT
UNIQ_ID,EMPLYR_ID,PASSWORD,EMPLYR_NM,ZIP,HOMEADRES,EMAIL_ADRES,GROUP_ID,'USR' AS USER_SE, ORGNZT_ID
FROM COMTNEMPLYRINFO
UNION ALL
SELECT UNIQ_ID,ENTRPRSMBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,'','ENT' AS USER_SE, '' AS ORGNZT_ID
FROM COMTNENTRPRSMBER
)
ORDER BY UNIQ_ID;
-----------------------------
그럼.. 즐거운 하루 되십시오..
말씀해 주신 부분을 확인해 보니깐..
View 생성 상에 사용자 구분 정보인 ENT와 USR이 서로 바뀌었습니다.
다음의 view 생성문을 다시 실행 시켜 주십시오..
-----------------------------
CREATE OR REPLACE FORCE VIEW COMVNUSERMASTER
(UNIQ_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID,USER_SE,ORGNZT_ID)
AS
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES, GROUP_ID,USER_SE,ORGNZT_ID
FROM (
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,'' GROUP_ID,'GNR' AS USER_SE, '' AS ORGNZT_ID
FROM COMTNGNRLMBER
UNION ALL
SELECT
UNIQ_ID,EMPLYR_ID,PASSWORD,EMPLYR_NM,ZIP,HOMEADRES,EMAIL_ADRES,GROUP_ID,'USR' AS USER_SE, ORGNZT_ID
FROM COMTNEMPLYRINFO
UNION ALL
SELECT UNIQ_ID,ENTRPRSMBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,'','ENT' AS USER_SE, '' AS ORGNZT_ID
FROM COMTNENTRPRSMBER
)
ORDER BY UNIQ_ID;
-----------------------------
그럼.. 즐거운 하루 되십시오..
