컴퓨팅

# # ProtectDB.properties 09/07/21 16:30:15 SafeNet, Inc. # # SafeNet Network-Attached Encryption (NAE) properties file # # Release Version: 5.4.0.000008 # # NOTE: Do not use quotes when specifying values in this file. # #[Version] # Version of the properties file for the SafeNet PKCS#11/ICAPI/MSCAPI/.NET # providers. # # Do not modify this property. #

// 복호화 SELECT “ing_row_id”,        “version_new” FROM   “ESVALI_TECH”.”tb_tech_history_hasu0707_new” WHERE  ( version_new IS NOT NULL ) ORDER  BY ing_row_id UPDATE “ESVALI_TECH”.”tb_tech_history_hasu0707_new” SET    “version” = ingrian.Ingrawtostring(?) WHERE  ing_row_id = ? // 테이블 정리 SELECT ing_row_id FROM   “ESVALI_TECH”.”tb_tech_history_hasu0707_new” ORDER  BY ing_row_id UPDATE “ESVALI_TECH”.”tb_tech_history_hasu0707_new” SET    “customer” = ‘ ‘ WHERE  ing_row_id = ? ALTER TABLE “ESVALI_TECH”.”tb_tech_history_hasu0707_new”   DROP COLUMN “version_new” 

// 컬럼 암호화 CREATE SEQUENCE “ESVALI_TECH”.”ING_SEQ_2″ NOCACHE  lock TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ IN EXCLUSIVE MODE  ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ADD ing_row_id INTEGER UPDATE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ SET    ing_row_id=”ESVALI_TECH”.ing_seq_2.NEXTVAL WHERE  ROWID=ROWID CREATE UNIQUE INDEX “ESVALI_TECH”.ing_idx_2 ON “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ( ing_row_id ) LOCK TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ IN EXCLUSIVE MODE ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ADD ( “ISSUE_NEW” RAW(528) ) ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ RENAME TO “TB_TECH_HISTORY_HASU0707_NEW” CREATE OR replace VIEW “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV” AS SELECT “INDEX”,        “DATE”,        “CUSTOMER”,        “PRODUCT”,        “VERSION”,        “ISSUE”,        “PROCESS”,        “ETC”,        “ING_ROW_ID” FROM   “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_NEW” CREATE OR replace VIEW “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ AS SELECT “INDEX” ,        “DATE” ,        “CUSTOMER” ,        “PRODUCT” ,        “VERSION” ,        “ISSUE” ,        “PROCESS” ,        “ETC” FROM   “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV”  CREATE OR replace TRIGGER “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0_INS_TRIG” instead OF  INSERT ON “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV” REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE check_22 VARCHAR2         (               512        );BEGIN   SELECT :NEW.”ISSUE”   INTO   check_22   FROM   dual;      INSERT INTO “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_NEW”               (                           “INDEX”,                           “DATE”,                           “CUSTOMER”,                           “PRODUCT”,                           “VERSION”,

1. INGRIAN 계정 생성 # Oracle 관리자 접속 sqlplus sys/비밀번호 as sysdba REM 테이블 스페이스 생성 CREATE TABLESPACE ts_ingrian DATAFILE ‘/oradata/orcl/ingrian.dbf’ SIZE 2M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE; REM 계정 생성 CREATE USER ingrian IDENTIFIED BY “비밀번호”; REM 테이블 스페이스 할당 ALTER USER ingrian DEFAULT TABLESPACE ts_ingrian; REM temp 테이블 스페이스 할당 ALTER USER

/xe/index.php?mid=linux&document_srl=4025 를 참조하여 리눅스 설치 후… yum -y install libaio yum -y install libaio-devel yum -y install libgcc yum -y install libstdc++ yum -y install sysstat yum -y install unixODBC yum -y install unixODBC-devel

■ Microsoft SQL Server Management Studio 에서 1. 개체탐색기→새 데이터베이스→”db_product” 생성 2. 개체탐색기→보안→로그인→”usr_product” 계정 추가 3. 개체탐색기→”usr_product” 속성→서버 역할→모든 권한 추가 ■ SQL 파일 실행 명령 프롬프트→ sqlcmd -S 10.10.10.91 -U usr_product -P “비밀번호” -d db_product -i create-tables.sql