﻿* SET_DB_O.TXT HARASAWA (Oracle)
*****( CREATE TABLE SPACE )**********************************
*(PERMISSION_BEGIN)*
=IF{_DB!='O'}JUMP{O_SKIP};
=MESSAGE{CREATE TABLESPACE};
REPEAT0=$W0PERMISSION
REPEAT=4
=LOGIN_SQL{CREATE TABLESPACE ?W_IS??W_##?_?W_PER$$?
= DATAFILE '?W_D##??_P??W_IS??W_##?_?W_PER$$?.ORA'
= SIZE 2M AUTOEXTEND ON NEXT 1M DEFAULT STORAGE
= (INITIAL 2M NEXT 1M PCTINCREASE 0) ONLINE}
=   IF{_DB_ERROR!='O1543'}ERROR{?_DB_ERROR??_ERROR?};
REPEAT0=
**********( CREATE USER )*****************
=MESSAGE{CREATE USER};
REPEAT0=$W0PERMISSION
REPEAT=2 (W_REAL_TEST##)
=SET{WPAS=W_PASSWORD_?W_REAL_TEST##?};
=SET{W_M_W='M'};
=SET{W0REPEAT2CNT=0};
REPEAT2=4 (W_DIOL--)
=COMPUTE{W0REPEAT2CNT+=1};
=MESSAGE{CREATE USER (?W_PER$$?)}; 
=SET{W_DIOL=W_DIOL?W0REPEAT2CNT?};
=IF{W0REPEAT2CNT=4}SET{WPAS=W_PASSWORD_LINK};
=SET{W_USER='?W_IS??W_R_T##?_?W_DIOL?_?W_PER$$?'};
=LOGIN_SQL{CREATE USER ?W_USER? IDENTIFIED BY ?WPAS?
=   DEFAULT TABLESPACE ?W_IS??W_R_T##?_?W_M_W?_?W_PER$$?}
=  IF{_DB_ERROR!='O1920'}ERROR{?_DB_ERROR??_ERROR?};
=LOGIN_SQL{GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO
=   ?W_USER?}ERROR{?_DB_ERROR??_ERROR?};
=LOGIN_SQL{GRANT CREATE VIEW TO ?W_USER?}
=  ERROR{?_DB_ERROR??_ERROR?};
=SET{W_M_W='W'};
REPEAT0=
*****( GRANT USER )******************************************
=MESSAGE{GRANT DBA};
=LOGIN_SQL{GRANT DBA TO ?W_IS?R_D_ZZZZ}
=  ERROR{?_DB_ERROR??_ERROR?};
=JUMP{O_SKIP};
*******( CREATE VIEW )***************************************
*****( OBJECT_VIEW )*****************************************
NAME=O_OBJECT_VIEW
=SET{WI=W_INSERT+'''O'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_TEXT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_ADD_DATE17,ZZZZZZ_CHANGE_DATE17)')};
COPY=ADD10
=SQL{?W?' AS SELECT CAST(''TABLE'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(T.OWNER,LENGTH(T.OWNER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(T.TABLE_NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(NULL AS NVARCHAR2(2000))')};
COPY=ADD10
=SQL{?W?',CAST(TO_CHAR(CREATED,''YYYYMMDDHH24MISS'')')};
COPY=ADD10
=SQL{?W?'||''000''  AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?' FROM ALL_ALL_TABLES T,ALL_OBJECTS O')};
COPY=ADD10
=SQL{?W?' WHERE T.OWNER IN')};
COPY=ADD10
=SQL{?W?'(?W_O_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND T.OWNER=O.OWNER')};
COPY=ADD10
=SQL{?W?' AND T.TABLE_NAME=OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' AND T.TABLE_NAME NOT LIKE ''BIN$%''')};
COPY=ADD10
=SQL{?W?' UNION SELECT CAST(''VIEW'' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(O.OWNER,LENGTH(O.OWNER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(VIEW_NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(NULL AS NVARCHAR2(2000))')};
COPY=ADD10
=SQL{?W?',CAST(TO_CHAR(O.CREATED,''YYYYMMDDHH24MISS'')')};
COPY=ADD10
=SQL{?W?'||''000'' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17)) FROM ALL_VIEWS V')};
COPY=ADD10
=SQL{?W?',ALL_OBJECTS O WHERE V.OWNER IN')};
COPY=ADD10
=SQL{?W?'(?W_O_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND V.OWNER=O.OWNER')};
COPY=ADD10
=SQL{?W?' AND V.VIEW_NAME=O.OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' UNION SELECT CAST(SUBSTR(S.TYPE,1,4)')};
COPY=ADD10
=SQL{?W?' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(S.OWNER,LENGTH(S.OWNER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(S.NAME  AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(S.TEXT AS NVARCHAR2(2000))')};
COPY=ADD10
=SQL{?W?',CAST(TO_CHAR(O.CREATED,''YYYYMMDDHH24MISS'')')};
COPY=ADD10
=SQL{?W?'||''000'' AS CHAR(17))')};
COPY=ADD10
=SQL{?W?',CAST('' '' AS CHAR(17)) FROM')};
COPY=ADD10
=SQL{?W?' ALL_SOURCE S,ALL_OBJECTS O')};
COPY=ADD10
=SQL{?W?' WHERE S.OWNER IN')};
COPY=ADD10
=SQL{?W?'(?W_O_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND S.OWNER=O.OWNER')};
COPY=ADD10
=SQL{?W?' AND S.NAME=O.OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' AND S.TYPE IN(''PROCEDURE'',''FUNCTION''')};
COPY=ADD10
=SQL{?W?',''TRIGGER'')')};
*****( COLUMN_VIEW )*****************************************
NAME=O_COLUMN_VIEW
=SET{WI=W_INSERT+'''O'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_SEQ')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DATA_NAME,ZZZZZZ_DEFAULT_TYPE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT_LENGTH1')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DEFAULT_LENGTH2,ZZZZZZ_DEFAULT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NULL)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE G.OBJECT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''TABLE'' THEN ''TABLE''')};
COPY=ADD10
=SQL{?W?' ELSE SUBSTR(G.OBJECT_TYPE,1,4)END')};
COPY=ADD10
=SQL{?W?' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(C.OWNER,LENGTH(C.OWNER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(C.TABLE_NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(C.COLUMN_ID AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(C.COLUMN_NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.DATA_TYPE WHEN ''NUMBER''')};
COPY=ADD10
=SQL{?W?' THEN CASE WHEN C.DATA_PRECISION IS NULL')};
COPY=ADD10
=SQL{?W?' THEN ''INT'' ELSE ''DECIMAL'' END')};
COPY=ADD10
=SQL{?W?' WHEN ''VARCHAR2''  THEN ''VARCHAR''')};
COPY=ADD10
=SQL{?W?' WHEN ''NVARCHAR2'' THEN ''NVARCHAR''')};
COPY=ADD10
=SQL{?W?' ELSE CASE WHEN C.DATA_TYPE LIKE')};
COPY=ADD10
=SQL{?W?' ''TIMESTAMP%'' THEN ''DATETIME''')};
COPY=ADD10
=SQL{?W?' ELSE SUBSTR(C.DATA_TYPE,1,9) END END')};
COPY=ADD10
=SQL{?W?' AS CHAR(9))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN C.DATA_TYPE=''NUMBER''')};
COPY=ADD10
=SQL{?W?' AND C.DATA_PRECISION IS NOT NULL')};
COPY=ADD10
=SQL{?W?' OR C.DATA_TYPE IN(''CHAR'',''VARCHAR2''')};
COPY=ADD10
=SQL{?W?',''NCHAR'',''NVARCHAR2'')')};
COPY=ADD10
=SQL{?W?' THEN CASE WHEN C.DATA_PRECISION IS NULL')};
COPY=ADD10
=SQL{?W?' THEN CASE WHEN C.DATA_TYPE')};
COPY=ADD10
=SQL{?W?' IN(''NCHAR'',''NVARCHAR2'')')};
COPY=ADD10
=SQL{?W?' THEN C.DATA_LENGTH/2')};
COPY=ADD10
=SQL{?W?' ELSE C.DATA_LENGTH END')};
COPY=ADD10
=SQL{?W?' ELSE C.DATA_PRECISION END')};
COPY=ADD10
=SQL{?W?' WHEN C.DATA_TYPE LIKE ''TIMESTAMP%''')};
COPY=ADD10
=SQL{?W?' THEN 17')};
COPY=ADD10
=SQL{?W?' WHEN C.DATA_TYPE=''DATE'' THEN 8')};
COPY=ADD10
=SQL{?W?' WHEN C.DATA_TYPE=''TEXT'' THEN 4000')};
COPY=ADD10
=SQL{?W?' ELSE 9 END AS INT)')};
COPY=ADD10
=SQL{?W?',CAST(CASE C.DATA_TYPE WHEN ''NUMBER''')};
COPY=ADD10
=SQL{?W?' THEN CASE WHEN C.DATA_SCALE IS NULL')};
COPY=ADD10
=SQL{?W?' THEN 0 ELSE C.DATA_SCALE END')};
COPY=ADD10
=SQL{?W?' ELSE 0 END AS INT),DATA_DEFAULT')};
COPY=ADD10
=SQL{?W?',CAST(CASE NULLABLE WHEN ''N''')};
COPY=ADD10
=SQL{?W?' THEN ''0'' ELSE ''1'' END')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM ALL_TAB_COLUMNS C')};
COPY=ADD10
=SQL{?W?',ALL_OBJECTS G WHERE')};
COPY=ADD10
=SQL{?W?' C.OWNER IN')};
COPY=ADD10
=SQL{?W?'(?W_O_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND C.OWNER=G.OWNER')};
COPY=ADD10
=SQL{?W?' AND C.TABLE_NAME=G.OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' AND C.TABLE_NAME NOT LIKE ''BIN$%''')};
COPY=ADD10
*****( INDEX_VIEW )******************************************
NAME=O_INDEX_VIEW
=SET{WI=W_INSERT+'''O'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_DATA_NAME,ZZZZZZ_IX')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_NO)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(K.TABLE_OWNER')};
COPY=ADD10
=SQL{?W?',LENGTH(K.TABLE_OWNER)-5,1)')};
COPY=ADD10
=SQL{?W?'   AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(K.TABLE_NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(K.COLUMN_NAME AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(I.INDEX_NAME')};
COPY=ADD10
=SQL{?W?',LENGTH(RTRIM(I.TABLE_NAME))+1,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(TO_CHAR(K.COLUMN_POSITION-CASE')};
COPY=ADD10
=SQL{?W?' I.UNIQUENESS WHEN')};
COPY=ADD10
=SQL{?W?' ''UNIQUE'' THEN 1 ELSE 0 END) AS INT)')};
COPY=ADD10
=SQL{?W?' FROM ALL_INDEXES I,ALL_IND_COLUMNS K')};
COPY=ADD10
=SQL{?W?' WHERE I.TABLE_NAME=K.TABLE_NAME')};
COPY=ADD10
=SQL{?W?' AND I.INDEX_NAME=K.INDEX_NAME ')};
COPY=ADD10
=SQL{?W?' AND I.INDEX_NAME IN(I.TABLE_NAME||''0''')};
COPY=ADD10
=SQL{?W?',I.TABLE_NAME||''1'',I.TABLE_NAME||''2''')};
COPY=ADD10
=SQL{?W?',I.TABLE_NAME||''3'',I.TABLE_NAME||''4''')};
COPY=ADD10
=SQL{?W?',I.TABLE_NAME||''5'',I.TABLE_NAME||''6''')};
COPY=ADD10
=SQL{?W?',I.TABLE_NAME||''7'',I.TABLE_NAME||''8''')};
COPY=ADD10
=SQL{?W?',I.TABLE_NAME||''9'') AND K.TABLE_OWNER IN')};
COPY=ADD10
=SQL{?W?'(?W_O_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND K.TABLE_OWNER=I.TABLE_OWNER')};
*****( GRANT_VIEW )******************************************
NAME=O_GRANT_VIEW
=SET{WI=W_INSERT+'''O'','};
COPY=ADD10
=SQL{?W?'(ZZZZZZ_KIND,ZZZZZZ_REAL,ZZZZZZ_WORK')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_USER,ZZZZZZ_NAME,ZZZZZZ_GRANT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_SELECT,ZZZZZZ_INSERT')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_UPDATE,ZZZZZZ_DELETE')};
COPY=ADD10
=SQL{?W?',ZZZZZZ_EXECUTE)AS SELECT')};
COPY=ADD10
=SQL{?W?' CAST(CASE G.OBJECT_TYPE')};
COPY=ADD10
=SQL{?W?' WHEN ''TABLE'' THEN ''TABLE''')};
COPY=ADD10
=SQL{?W?' ELSE SUBSTR(G.OBJECT_TYPE,1,4) END')};
COPY=ADD10
=SQL{?W?' AS CHAR(5))')};
COPY=ADD10
=SQL{?W?',CAST(''?_Q?_REAL_TEST?_Q?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(''?W_MAST_WORK?'' AS CHAR(4))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(G.OWNER,LENGTH(G.OWNER)-5,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(G.OBJECT_NAME  AS NCHAR(30))')};
COPY=ADD10
=SQL{?W?',CAST(CASE WHEN LENGTH(RTRIM(G0.GRANTEE))')};
COPY=ADD10
=SQL{?W?'>6 THEN SUBSTR(G0.GRANTEE')};
COPY=ADD10
=SQL{?W?',LENGTH(RTRIM(G0.GRANTEE))-5)')};
COPY=ADD10
=SQL{?W?' ELSE G0.GRANTEE END AS CHAR(6))')};
COPY=ADD10
=SQL{?W?',CAST(CASE G0.PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''SELECT''')};
COPY=ADD10
=SQL{?W?' THEN ''S'' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(G1.PRIVILEGE,1,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(G2.PRIVILEGE,1,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(SUBSTR(G3.PRIVILEGE,1,1)')};
COPY=ADD10
=SQL{?W?' AS CHAR(1))')};
COPY=ADD10
=SQL{?W?',CAST(CASE G0.PRIVILEGE')};
COPY=ADD10
=SQL{?W?' WHEN ''EXECUTE'' THEN ''E''')};
COPY=ADD10
=SQL{?W?' ELSE '' '' END AS CHAR(1))')};
COPY=ADD10
=SQL{?W?' FROM ALL_OBJECTS G')};
COPY=ADD10
=SQL{?W?' INNER JOIN ALL_TAB_PRIVS G0')};
COPY=ADD10
=SQL{?W?' ON G0.PRIVILEGE')};
COPY=ADD10
=SQL{?W?' IN(''SELECT'',''EXECUTE'')')};
COPY=ADD10
=SQL{?W?' AND G0.GRANTOR=G.OWNER')};
COPY=ADD10
=SQL{?W?' AND G0.TABLE_NAME=G.OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' LEFT JOIN ALL_TAB_PRIVS G1')};
COPY=ADD10
=SQL{?W?' ON G1.PRIVILEGE=''INSERT''')};
COPY=ADD10
=SQL{?W?' AND G1.GRANTOR=G.OWNER')};
COPY=ADD10
=SQL{?W?' AND G1.TABLE_NAME=G.OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' AND G1.GRANTEE=G0.GRANTEE')};
COPY=ADD10
=SQL{?W?' LEFT JOIN ALL_TAB_PRIVS G2')};
COPY=ADD10
=SQL{?W?' ON G2.PRIVILEGE=''UPDATE''')};
COPY=ADD10
=SQL{?W?' AND G2.GRANTOR=G.OWNER')};
COPY=ADD10
=SQL{?W?' AND G2.TABLE_NAME=G.OBJECT_NAME ')};
COPY=ADD10
=SQL{?W?' AND G2.GRANTEE=G0.GRANTEE')};
COPY=ADD10
=SQL{?W?' LEFT JOIN ALL_TAB_PRIVS G3')};
COPY=ADD10
=SQL{?W?' ON G3.PRIVILEGE=''DELETE''')};
COPY=ADD10
=SQL{?W?' AND G3.GRANTOR=G.OWNER')};
COPY=ADD10
=SQL{?W?' AND G3.TABLE_NAME=G.OBJECT_NAME')};
COPY=ADD10
=SQL{?W?' AND G3.GRANTEE=G0.GRANTEE')};
COPY=ADD10
=SQL{?W?' WHERE G.OWNER IN')};
COPY=ADD10
=SQL{?W?'(?W_O_OWNER?)')};
COPY=ADD10
=SQL{?W?' AND (OBJECT_TYPE')};
COPY=ADD10
=SQL{?W?' IN(''TABLE'',''VIEW'')')};
COPY=ADD10
=SQL{?W?' AND G0.PRIVILEGE=''SELECT''')};
COPY=ADD10
=SQL{?W?' OR OBJECT_TYPE')};
COPY=ADD10
=SQL{?W?' IN(''PROCEDURE'',''TRIGGER'')')};
COPY=ADD10
=SQL{?W?' AND G0.PRIVILEGE=''EXECUTE'')')};
COPY=ADD10
=SQL{?W?' AND (G0.GRANTEE LIKE')};
COPY=ADD10
=SQL{?W?' ''?_Q?_DB_HEADER?_Q?%''')};
COPY=ADD10
=SQL{?W?' OR G0.GRANTEE =''PUBLIC'')')};
COPY=ADD10
=SQL{?W?' AND G.OBJECT_NAME NOT LIKE ''BIN$%'' ')};
NAME=
*************************************************************
=O_SKIP:
=SET{_REAL_TEST='REAL'};
*(PERMISSION_END)*
