67 Copyright © 2020, Oracle and/or its affiliates. All rights reserved.
Oracle Data Safe監査シナリオ
アクティビティ監査
CREATE TABLE "DEMO"."EMPLOYEES" (
"EMPLOYEE_ID" NUMBER(6,0) NOT NULL PRIMARY KEY,
"FIRST_NAME" VARCHAR2(20),
"LAST_NAME" VARCHAR2(25),
"EMAIL" VARCHAR2(25),
"PHONE_NUMBER" VARCHAR2(25),
"HIRE_DATE" DATE,
"JOB_ID" VARCHAR2(10),
"SALARY" NUMBER(8,2),
"CARD_NO" NUMBER(16,0),
"MANAGER_ID" NUMBER(6,0),
"DEPARTMENT_ID" NUMBER(4,0)
);
insert into DEMO.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,CARD_NO,MANAGER_ID,DEPARTMENT_ID) values
(100,'Alberto','Errazuriz','
[email protected]','011.44.1344.429278',to_date( '2020-12-20' , 'YYYY-MM-
DD'),'SA_MAN',12000,6212345678900001,100,80);
insert into DEMO.EMPLOYEES
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,CARD_NO,MANAGER_ID,DEPARTMENT_ID) values
(110,'Bruce','Ernst','
[email protected]','590.423.4568',to_date('2020-12-21' , 'YYYY-MM-DD'),'IT_PROG',6000,6212345678900002,103,60);
①作成したDEMOユーザーを利⽤し、
ターゲットのPDBにテストデータを作成