IT창고

USE UNIERP

GO

-- UPDATE Z_USR_MAST_REC SET
        USR_VALID_DT = '2999-12-31 00:00:00.000', PWD_VALID_DT = '2999-12-31 00:00:00.000';

USE UNIERP

GO

SELECT USR_ID, PWD

    FROM Z_USR_MAST_REC

    WHERE USR_ID = 'UNIERP';

-- UPDATE Z_USR_MAST_REC SET
        PWD = '사전 조회후 저장해 둔 암호값' WHERE USR_ID = 'UNIERP';

USE UNIERP

GO

SELECT * FROM B_MAJOR WHERE MAJOR_CD = 'Z0010';
SELECT * FROM B_MINOR WHERE MAJOR_CD = 'Z0010';

SELECT * FROM Z_LOG_IN_HSTRY WHERE STATUS IN ('4') ORDER BY LOGIN_DT DESC;

-- UPDATE Z_LOG_IN_HSTRY SET

        STATUS = '5' WHERE STATUS = '4' AND USR_ID = 'UNIERP';

UNIERP.사원정보조회.sql