cr_flagged_access.sql

来自「Oracle PLSQL for DBAs 源代码」· SQL 代码 · 共 44 行

CREATE TABLE flagged_access
(
   fgasid            NUMBER(20),
   entryid           NUMBER(20),
   audit_date        DATE,
   fga_policy        VARCHAR2(30),
   db_user           VARCHAR(30),
   os_user           VARCHAR2(30),
   authent_type      VARCHAR2(30),
   client_id         VARCHAR2(100),
   client_info       VARCHAR2(64),
   host_name         VARCHAR2(54),
   instance_id       NUMBER(2),
   ip                VARCHAR2(30),
   term              VARCHAR2(30),
   schema_owner      VARCHAR2(20),
   table_name        VARCHAR2(30),
   sql_text          VARCHAR2(64),
   SCN               NUMBER(10)
)
TABLESPACE audit_ts
PARTITION BY RANGE (audit_date)
(
   PARTITION y04m01 VALUES LESS THAN
      (TO_DATE('02/01/2004','mm/dd/yyyy')),
   PARTITION y04m02 VALUES LESS THAN
      (TO_DATE('03/01/2004','mm/dd/yyyy')),
   PARTITION y04m03 VALUES LESS THAN
      (TO_DATE('04/01/2004','mm/dd/yyyy')),
   PARTITION y04m04 VALUES LESS THAN
      (TO_DATE('05/01/2004','mm/dd/yyyy')),
   PARTITION y04m05 VALUES LESS THAN
      (TO_DATE('06/01/2004','mm/dd/yyyy')),
   PARTITION y04m06 VALUES LESS THAN
      (TO_DATE('07/01/2004','mm/dd/yyyy')),
   PARTITION y04m07 VALUES LESS THAN
      (TO_DATE('08/01/2004','mm/dd/yyyy')),
   PARTITION y04m08 VALUES LESS THAN
      (TO_DATE('09/01/2004','mm/dd/yyyy')),
   PARTITION def VALUES LESS THAN
      (MAXVALUE)
)
/